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

Answer Posted / santo

export/import...attach/detach...DTS....backup/restore!

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2196


what is a user-defined lock?

590


how can a session indicate its interest in receiving alerts?

567


Query processing is slow(eg select query)how will u solve that

6528


What is fill factor? : sql server DBA

648






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

1339


Explain materialized views and how they are used.

1898


who owns the operating system files created by the utl_file package?

569


What is the difference between dropping a database and taking a database offline? : sql server DBA

582


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

1685


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

2112


Why would you use sql agent? : sql server DBA

582


suppose you want to audit specific activities on sensitive data. How can you achieve that?

552


Which autogrowth database setting is good? : sql server DBA

581


what is the role of dip user in our database?

2053