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

How to create a simple stored procedure in ms sql server?

0 Answers  

How to install sql server 2005 express edition?

0 Answers  

Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,

in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers  

Why are views required in the sql server or in any other database?

0 Answers  

In what three ways is the return statement used in a stored procedure?

0 Answers  

Why is the need for data conversion transformations?

0 Answers  

what is a check constraint?

0 Answers  

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

Mention the differences between substr and charindex in sql server.

0 Answers  

What is default port number for sql server 2000?

0 Answers  

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories