Restoring a Database Backup 

This chapter 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.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:

http://msdn.microsoft.com/en-us/library/ms191253%28v=SQL.100%29.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%28v=SQL.100%29.aspx
	How to: Restore a Database Backup (SQL Server Management Studio)	http://msdn.microsoft.com/en-us/library/ms177429%28v=SQL.100%29.aspx
	How to: Create a New Database From an Existing Database Backup (SQL Server Management Studio)	http://msdn.microsoft.com/en-us/library/ms190447%28v=SQL.100%29.aspx
	Performing a Complete Database Restore (Full Recovery Model)	http://msdn.microsoft.com/en-US/library/ms187495(v=SQL.100).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.100).aspx
	How to: Restore a Differential Database Backup (SQL Server Management Studio)	http://msdn.microsoft.com/en-us/library/ms175510%28v=SQL.100%29.aspx
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%28v=SQL.100%29.aspx
	How to: Restore a Transaction Log Backup (SQL Server Management Studio)	http://msdn.microsoft.com/en-us/library/ms177446%28v=SQL.100%29.aspx