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 are the steps you will take to improve performance of a poor performing query?

0 Answers  

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

How would you determine who has added a row to a table?

4 Answers  




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

0 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 is ora 600?

1 Answers  

Oracle 11g new features?

2 Answers  

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

For more DB Administration Interview Questions Click Here
Categories