Restoring a Database Backup 

This section provides information about how to restore the SQL Server database.

For more information, see:

·        SQL Server Books Online at:

http://msdn.microsoft.com/en-us/library/ms130214(v=sql.90).aspx

http://msdn.microsoft.com/en-us/library/ms130214(v=sql.100).aspx

http://msdn.microsoft.com/en-us/library/ms130214(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/ms130214(v=sql.12).aspx

·        MSDN Library at

http://msdn.microsoft.com/en-us/library

A general overview about restoring and recovering the SQL Server database, is available in the SQL Server Books Online at:

SQL Server 2005:

http://msdn.microsoft.com/en-us/library/ms130214(v=sql.90).aspx

SQL Server 2008:

http://msdn.microsoft.com/en-us/library/ms191253(v=SQL.100).aspx

SQL Server 2008 R2:

http://msdn.microsoft.com/en-us/library/ms191253(v=SQL.105).aspx

SQL 2012:

http://msdn.microsoft.com/en-us/library/ms191253(v=sql.12).aspx

The following table provides information about how to restore full database backup, a differential database backup, and how to restore a transaction log backup for SQL Server:

 

Description	Title	Where to find
Restore a full database backup	How to: Restore a Database Backup (Transact-SQL)	http://msdn.microsoft.com/en-us/library/ms189895(v=SQL.90).aspx http://msdn.microsoft.com/en-us/library/ms189895%28v=SQL.100%29.aspx http://msdn.microsoft.com/en-us/library/ms189895(v=SQL.105).aspx http://msdn.microsoft.com/en-us/library/ms189895(v=SQL.12).aspx
	How to: Restore a Database Backup (SQL Server Management Studio)	http://msdn.microsoft.com/en-us/library/ms177429(v=SQL.90).aspx http://msdn.microsoft.com/en-us/library/ms177429%28v=SQL.100%29.aspx http://msdn.microsoft.com/en-us/library/ms177429(v=SQL.105).aspx http://msdn.microsoft.com/en-us/library/ms177429(v=SQL.12).aspx
Restore a differential database backup	How to: Restore a Differential Database Backup (Transact-SQL)	http://msdn.microsoft.com/en-us/library/ms178105(v=SQL.90).aspx http://msdn.microsoft.com/en-us/library/ms178105(v=SQL.100).aspx http://msdn.microsoft.com/en-us/library/ms178105(v=SQL.105).aspx http://msdn.microsoft.com/en-us/library/ms175510#TsqlProcedure
	How to: Restore a Differential Database Backup (SQL Server Management Studio)	http://msdn.microsoft.com/en-us/library/ms175510%28v=SQL.100%29.aspx http://msdn.microsoft.com/en-us/library/ms175510(v=SQL.105).aspx http://msdn.microsoft.com/en-us/library/ms175510#SSMSProcedure
Restore a transaction log backup After you restore your data backup or backups, you must restore all of the later transaction log backups and then recover the database.	How to: Apply a Transaction Log Backup (Transact-SQL)	http://msdn.microsoft.com/en-us/library/ms187607(v=SQL.90).aspx http://msdn.microsoft.com/en-us/library/ms187607%28v=SQL.100%29.aspx http://msdn.microsoft.com/en-us/library/ms187607(v=SQL.105).aspx http://msdn.microsoft.com/en-us/library/ms177446#TsqlProcedure
	How to: Restore a Transaction Log Backup (SQL Server Management Studio)	http://msdn.microsoft.com/en-us/library/ms177446(v=SQL.90).aspx http://msdn.microsoft.com/en-us/library/ms177446%28v=SQL.100%29.aspx http://msdn.microsoft.com/en-us/library/ms177446(v=SQL.105).aspx http://msdn.microsoft.com/en-us/library/ms177446#SSMSProcedure