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

How to update a field in SQL after ALTERING a row?

1 Answers   Amdocs,


List the advantages of using stored procedures?

1 Answers  


How to change server name in sql server?

1 Answers  


How do I find the size of a sql server database?

1 Answers  


What is abstracting periodical?

1 Answers  


What are information schema views?

1 Answers  


How to select true false based on column value in sql server?

1 Answers  


How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,


What is the difference between grant and with grant while giving permissions to the user?

1 Answers  


What do you understand by integration services in sql server?

1 Answers  


How to delete duplicate rows from table except one?

1 Answers  


WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,


Categories