Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

hi i am having .mdf file and .ldf file ..how can i get the all
table in my .mdf..plz give solution

Question Posted / guest

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

What are the types of sql server?

0 Answers  

How can we remove orphan records from a table?

0 Answers  

What is clustered index

0 Answers  

Define primary key?

0 Answers  

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,

What is tempdb in sql server?

0 Answers  

What happens if we shrink log file in sql server?

0 Answers  

What number sorts of privileges are accessible in sql?

0 Answers  

How to convert numeric values to integers in ms sql server?

0 Answers  

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

how you can get the list of largest tables in a database? : Sql server administration

0 Answers  

How do I view a script in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories