Backup and Restore Considerations


Topic Last Modified: 2005-05-23

At this point, you should understand that there are important implications for backup and restoration whenever you move a database from one storage group to another. In general, anything that you do that detaches a database from one set of log files and attaches it to another will probably affect your ability to roll the database forward from backup. This does not mean your backups are invalidated by attaching a database to a different log file stream, but it does mean that your ability to bring an old backup completely up-to-date is compromised. As a general principle, after you attach a database to a different log file stream, you should immediately make a new backup to ensure that you can roll the database completely forward.