Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

hi i am having .mdf file and .ldf file ..how can i get the all
table in my .mdf..plz give solution

Question Posted / guest

Answers were Sorted based on User's Feedback



hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution..

Answer / samba shiva reddy . m

Right click on Databases then click on attach it will pop window (Attach Database) then click on add button then select the .mdf file then automatically it will select the .ldf file
then click on Ok
that data base is ready for use.

Is This Answer Correct ?    3 Yes 0 No

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution..

Answer / venkat reddy.ravu

First create a floder on the drive.copy and paste .mdf
and .ldf files into that folder.

Connect to database engine
|
Object Explorere
|
Databases(Right click)
|
Attach

select the .mdf file ,then .ldf will be automatically
selected.in the pouup window window you will bew asked to
enter the database name.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How many non clustered indexes there can be on table ?

0 Answers  

What is self contained multi valued query?

0 Answers  

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  

What are the advantages of partitioning?

0 Answers  

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

How to Execute an Operating System Command From Within SQL Server ?

3 Answers  

How to handle errors in Stored Procedures.

2 Answers   Accenture,

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

Explain important index characteristics?

0 Answers  

can an automatic recovery be initiated by a user? : Sql server administration

0 Answers  

What is normalization? Explain its different types?

0 Answers   GE, Maveric,

Explain ms sql server reporting services vs crystal reports?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories