About restoring SQL databases and file groups

You can restore a database by using one job or using multiple jobs to restore all of the backup sets. The number of jobs you decide on depends on the types of backup jobs that protect the database or the file group. If you use one job to restore a database, select all the backup sets that you want to apply. Include the full backup, any differential backups, and any log backups. Also select the Leave the database ready to use option. Additional transaction logs cannot be restored. Single-job restores and multiple-job restores can both be used in redirected restore operations.

Some restore operations must be completed using separate restore jobs to recover data.

These operations include the following:

If you use multiple jobs to restore a database, ensure that you specify the recovery completion state Leave the database nonoperational. Additional transaction logs can be restored for all the jobs except the last one. For the last job, you should specify the recovery completion state Leave the database ready to use. If you use this recovery state, additional transaction logs cannot be restored.

SQL database files contain unused space so that the disk file does not have be grown every time a small amount of data is added to the database. SQL fills the unused space with zeros. When SQL databases are restored, it is not known how much of the file will actually be used by the restored data, so SQL creates the required database files on disk and then fills them with zeros.

With very large databases this process can take several hours to complete. During this time Backup Exec reports that no data is being transferred, and the Byte count field in the Job Monitor view is not updated. When SQL has completed filling the files with zeros, the restore job continues. This occurs for all database restores but is noticeable only on very large databases.

In a mirrored configuration, the primary SQL database cannot be restored. To restore the primary SQL database, you must stop database mirroring of the primary database.

Note:

SQL 7.0 database backups can be restored to SQL 2000 and SQL 2005, but SQL 2000 and SQL 2005 backups cannot be restored to SQL 7.0.

More Information

Restoring data by setting job properties

Restoring from SQL transaction logs up to a point in time

Restoring from SQL 2000, SQL 2005 or SQL 2008 transaction logs up to a named transaction

Restoring from SQL filegroup backups

Redirecting restores for SQL