Performing File Restores
This topic is relevant only for databases that contain multiple filegroups (and, under the simple model, only for databases that contain a read-only filegroup).
Note
For information on file permissions that are set whenever a database is backed up or restored, see Securing Data and Log Files.
In This Section
- Restoring File Backups (Simple Recovery Model)
Discusses how to restore file backups taken on a simple-model database.
- Restoring File Backups (Full Recovery Model)
Discusses how to restore file backups taken on a full-model database.
- File Backup and Restore Considerations for Related Features
Contains information about the operation of other features with respect to file backup and restore in Microsoft SQL Server 2005.
See Also
Concepts
Differential Backups and New Files
Placing Indexes on Filegroups
Differential File Backups
Understanding How Restore and Recovery of Backups Work
Using Files and Filegroups to Manage Database Growth
Using Files and Filegroups
Other Resources
Designing Files and Filegroups
File Backup and Restore Considerations for Related Features