Use this dialog box to restore SQL Server database objects.
What can I do from this dialog box?
Start a restore operation
Viewing properties of objects selected for restore
Field descriptions
About selecting database objects for restore
Restore Microsoft SQL Server Objects field descriptions
Procedures
Browsing for backup images
Restoring a database backup
Staging a full database recovery
Restoring filegroup backups
Recovering a database from read-write backups
Restoring read-only filegroups (SQL Server 2005 or later)
Restoring database files
Restoring a transaction log image without staging a full recovery
Performing a database move
Restoring partial databases (SQL Server 2000)
Performing page-level restores (SQL Server 2005 or later)
Redirecting a restore to a different host
Redirecting a database to a different location on a different host
Related topics
Performing restores with a multi-NIC connection
Backing up and restoring the databases that contain full-text search catalogs (SQL Server 2005 or later)
Performing backups and restores of remote SQL Server installations
Restoring multistreamed backups
Performing a restore on a virtual SQL Server instance
Performing restores in a cluster with a multi-NIC connection
Performing SQL Server snapshot restores
About backups and restores in an SAP environment
Using NetBackup to restore SQL Server from Backup Exec images