Export (0) Print
Expand All

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.

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.

NoteNote

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.

Community Additions

ADD
Show:
© 2014 Microsoft