Chapter 4. Transferring Your Database to Other Systems
After completing this chapter, you will be able to:
Use backup and restore techniques to move your data
Detach, copy, and re-attach your database to move the data
Understand when replication may be the best option
Use SQL Server Integration Services (SSIS) to move tables and databases
Schedule jobs to automate data movement between servers
So, you need to have your data in more than one place. You might distribute your data for performance or to provide for disaster recovery. Maybe you have a corporate center that needs to distribute data to regional or local offices. There can be many reasons to move your data.
When determining the scope of your data distribution needs, you should consider ...
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
