What are the different ways of moving data/datab

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

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.

(Continued on next question...)

Other Job Interview Questions

• What is RAID and what are different types of RAID configurations?
• What are the steps you will take to improve performance of a poor performing query?
• What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
• Let’s assume you have data that resides on SQL Server 6.5. You have to move it SQL Server 7.0. How are you going to do it?
• CREATE INDEX myIndex ON myTable(myColumn)What type of Index will get created after executing the above statement?
• What is database replication? What are the different types of replication you can set up in SQL Server?
• What kind of LAN types do you know?
• But what if you have to create a database with two filegroups, one on drive C and the other on drive D with log on drive E with an initial size of 600 MB and with a growth factor of 15%?
• What is database replication? What are the different types of replication you can set up in SQL Server?
• What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
• More...