hi i am having .mdf file and .ldf file ..how can i get the all
table in my .mdf..plz give solution
Answer Posted / 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 View All Answers
what are user defined datatypes and when you should go for them? : Sql server database administration
Explain triggers?
What is use of except clause? How it differs from not in clause?
What are two difference between sql azure and azure tables?
What is an execution plan? How would you view the execution plan?
How do I start sql server 2016?
What is the contrast between sql and pl/sql?
Explain the flow of creating a cube? : sql server analysis services, ssas
Can primary key be a foreign key?
What is the full form of dql?
What are views in ms sql server?
What is a collation in ms sql server?
what is raid? : Sql server database administration
How do I find query history in sql server?
How do I find the sql server instance name?