Backup and Restore Considerations for Related Features
The topics in this section describe the operation of other features with regard to backup and restore in SQL Server 2008.
In This Section
File Restore and Database Startup
Discusses how to manage a file that is preventing a database from starting.Online Restore and Disabled Indexes
Contains information about how to restore an offline file to a database in order to enable a disabled index.Database Mirroring and Backup and Restore
Discusses how backup and restore is affected by and affects database mirroring.Piecemeal Restore and Full-Text Indexes
Discusses how backup and restore affects full-text indexes.File Backup and Restore and Compression
Discusses how restore works with a read-only filegroup that is compressed by using NTFS file system data compression.
Note
Backing up and restoring databases or files that are involved in replication includes additional considerations. For more information, see Backing Up and Restoring Replicated Databases.