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

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

3 Answers  

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

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

0 Answers  

which background process will run @ the time of creation of catalog database

1 Answers   CSC,




how can you initialize log miner?

0 Answers   Oracle,

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

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 ways you can create databases in sql server? : sql server DBA

0 Answers  

how to restore files with rman?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories