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 / pandians

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

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

1594

what is asm?

692

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

785

how can you find out if a table can be redefined?

686

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

674




which background process invoke at the time of upgradation tell me???

2326

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

691

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

939

Which autogrowth database setting is good? : sql server DBA

653

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1929

What are the steps you will take to improve performance of a poor performing query?

2499

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1605

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?

2273

how can you schedule a job in database?

676

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

2211