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

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

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 Answers  


What is the purpose of the model database?

0 Answers  


what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,


What is the difference between createstatement and preparedstatement?

0 Answers  


What is an entity-relationship diagram (erd)?

0 Answers  






Tell me what is difference between clustered and non clustered index?

0 Answers  


what is a self join? Explain it with an example? : Sql server database administration

0 Answers  


What is an index?

8 Answers   Yardi Software,


What types of integrity are enforced by a foreign-key constraint

1 Answers  


How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  


What is tablesample?

0 Answers  


Can sql servers link to other servers?

0 Answers  


Categories