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
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 |
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 |
Characterize join and name diverse sorts of joins?
how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.
What is blocking and how would you troubleshoot it?
Explain in brief about Microsoft SQL server?
Which are new data types introduced in sql server 2008?
What is onf in normalization form?
How you can change the database name in SQL SERVER?
Which is faster statement or preparedstatement?
How do I connect to sql server database?
What is schemabinding a view?
how to determine the service pack currently installed on sql server? : Sql server database administration
Why the trigger fires multiple times in single login?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)