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 >> DB Administration
  2. Suggest New Category

What are the different ways of moving data or databases
between servers and databases in SQL Server?

Question Posted / guest

Answers were Sorted based on User's Feedback



What are the different ways of moving data or databases between servers and databases in SQL Serve..

Answer / pandians

Moving Data :
-------------
1. Configuring Linked Server between servers and move the
data using four part naming convension
i.e: Server.Database.Schema.Table
2. Use Export and Import wizard
3. Using SSIS or DTS Package to move data to different
database or server
4. Use three part naming convension to move data to
different database within the server/instance.
5. Using BCP to move data.

Moving Database:
----------------
1. Detach...Attach
2. Backup and Restore
3. Stop the Service
3.1 Using Alter statement to relocate the database path
3.2 Copy the files into new location
3.3 Start the Service
4. But, Moving system database except Master and Resource
can follow the above way

Is This Answer Correct ?    5 Yes 0 No

What are the different ways of moving data or databases between servers and databases in SQL Serve..

Answer / santo

export/import...attach/detach...DTS....backup/restore!

Is This Answer Correct ?    2 Yes 1 No

What are the different ways of moving data or databases between servers and databases in SQL Serve..

Answer / monal

BCP (BULK COPY PROGRAM)

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB Administration Interview Questions

how will you see when the database was started using sql prompt?

2 Answers   IBM,

How do you add a data file to a tablespace?

3 Answers  

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

What purpose does the model database server? : sql server DBA

0 Answers  

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

what is logical system in sap basis

0 Answers  

What is the difference between Datapump & export/import?

2 Answers  

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories