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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2342


what is ora 24313?what is the procedure to exclude that error?

2339


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2185


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1739


What are the commands you'd issue to show the explain plan for "select * from dual"?

1990


What the different types of replication and why are they used? : sql server DBA

865


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1861


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2200


What are the operating modes in which database mirroring runs? : sql server DBA

866


What are statistics, under what circumstances they go out of date, how do you update them?

2015


What is a correlated sub-query? : sql server DBA

787


How do you trace the traffic hitting a sql server? : sql server DBA

1166


how can you schedule a job in database?

821


can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1530


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?

2422