SQL Server Restores

Supported SQL Server databases can be restored using either File restore or Block restore.

See also. For the latest system compatibility details regarding supported hardware, file systems, applications, operating systems, and service packs, see the Compatibility Guide.

While you are restoring a single SQL Server database, all other databases on the SQL Server will still be available for transactions. However, the database that is being restored will not be available, and while you are restoring the master database, none of the databases on the SQL Server will be available.

If you select an entire SQL Server disk for restore, the master database is excluded from the restore; that is, the SQL Server master database is not automatically restored. You must explicitly set up a restore job for the master database by separately selecting the master database.

If a database exists when you are restoring it, SQL Server checks to make sure that it is the correct place to which you want to restore the data. If this check succeeds, the database is overwritten. If this check fails, the restore fails. To override this check, see the Setting Restore Destination Options topics in Chapter 20: Microsoft SQL Server.

When you are restoring a SQL Server database and the database no longer exists, it is not necessary to manually recreate the database before restoring the data. DPX will restore your entire database, tables and data.

Related Topics:

Last updated