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



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

Answer / swapna

There are lots of options available, you have to choose
your option depending upon your requirements.

Some of the options you have are: BACKUP/RESTORE,
dettaching and attaching databases, replication, DTS, BCP,
logshipping, INSERT...SELECT, SELECT...INTO, creating
INSERT scripts to generate data.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  


What is pivot and unpivot?

0 Answers  


How do I install only the client tools of sql server 2000?

0 Answers  


How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,


what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  






Are connections to sql server encrypted?

0 Answers  


What is dirty page?

0 Answers  


How to use the inserted and deleted pseudo tables?

0 Answers  


When we should use and scope of @@identity?

0 Answers  


Explain nested trigger in sql?

0 Answers  


What structure can you implement for the database to speed up table reads?

0 Answers  


What are the triggers in sql?

0 Answers  


Categories