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 do you understand by replication in sql server?

0 Answers  

What is an active database?

0 Answers   HCL,

What do you know about system database? : SQL Server Architecture

0 Answers  

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

What are key constraints?

0 Answers  

How many databases instances are there in sql server 2000?

0 Answers  

can any one please send sql quries most used in applications.

2 Answers  

What are the types of database schema? : sql server analysis services, ssas

0 Answers  

How do triggers work?

0 Answers  

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

How to make a remote connection in a database?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories