What are the different ways of moving data or databases between servers and da

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

Question Posted / guest

3 Answers
8537 Views
I also Faced
E-Mail Answers

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

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers

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

1 Answers Cap Gemini, iGate,

how can you process messages in order asynchronously?

0 Answers Oracle,

How would you begin to troubleshoot an ORA-3113 error?

1 Answers

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers IBM,

What background process refreshes materialized views?

2 Answers Accenture, FLSmidth,

how can you connect from 10g user to 11g user??

0 Answers HP,

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers

What view would you use to determine free space in a tablespace?

3 Answers

What is the difference between online backup & offline backup?

3 Answers CSC,

For more DB Administration Interview Questions Click Here