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 |
What is raid and what are different types of raid levels?
What is triggers and its types?
I have to display ten columns values from diffrent ten tables. how many joins are require?
10 Answers CarrizalSoft Technologies, HCL,
What is isnull() operator?
What are the built in functions in sql server?
What is a sql join?
How do I find the size of a sql server database?
Your table has a large character field there are queries that use this field in their search clause what should you do?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
what are the limitations of parameters in a storedprocedure
What is partitioned view?
i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?
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)