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

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  


What is "scheduled jobs" or "scheduled tasks"?

0 Answers  


What is the difference between varchar and nvarchar datatypes?

0 Answers  


What is a join and their types?

2 Answers   Challenger Financial,


What do you mean by an execution plan? How would you view it?

0 Answers  






what is sql server? : Sql server database administration

0 Answers  


Explain what is analysis service repository?

0 Answers  


What is the difference between value type and reference type?

0 Answers  


What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,


Explain Geometry datatype in sql server 2008 with example

0 Answers   Infosys,


What methods do you follow to protect from sql injection attack?

0 Answers  


explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  


Categories