Using Backup and Restore to Transfer Your Data
What? Use backup and restore as a transfer method? Sure! One of the key advantages of using backups is that they have minimal impact on the operation of your system. A backup is a live operation that allows you to continue conducting business while it is running. There are three types of backups that can be used, each of which is appropriate in different situations. The three types are full database backups, differential backups, and transaction log backups. Detailed information about these backup types and their appropriate uses is given in Chapter 3.
All of the backup strategies use a full backup as the starting point, so you will need to plan for it first. The backup strategy you employ for transferring ...
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.
