hi i am having .mdf file and .ldf file ..how can i get the all
table in my .mdf..plz give solution
Answer Posted / 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 |
Post New Answer View All Answers
System variable and temporary variables
How do you drop an index?
How to rebuild all indexes on a single table?
how to invoke a trigger on demand? : Sql server database administration
What is a periodical index?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Explain in brief about Microsoft SQL server?
what is a self join? Explain it with an example? : Sql server database administration
What are the different acid properties?
What is molap and its advantage? : sql server analysis services, ssas
What is the current limitation of the size of SQL Azure DB?
How to generate random numbers with the rand() function in ms sql server?
What is a schema in ms sql server 2005?
How to drop an existing table with "drop table" statements in ms sql server?
Explain a checkpoint?