Backing Up and Restoring How-to Topics (SQL Server Management Studio)
The backup and restore component of Microsoft SQL Server 2005 provides an essential safeguard to help protect critical data that is stored in SQL Server databases. The topics in this section explain how to use SQL Server Management Studio to create and restore databases, differential databases, transaction logs, and file and filegroup backups. However, for partial or copy-only backups, you must use the Transact-SQL BACKUP statement with the PARTIAL or COPY_ONLY option, respectively.
In This Section
Backup How-to Topics
- How to: Back Up a Database (SQL Server Management Studio)
- How to: Back Up a Transaction Log (SQL Server Management Studio)
- How to: Back Up Database Files and Filegroups (SQL Server Management Studio)
- How to: Back Up to Tape or Disk (SQL Server Management Studio)
- How to: Create a Differential Database Backup (SQL Server Management Studio)
- How to: Define a Logical Backup Device for a Disk File (SQL Server Management Studio)
- How to: Define a Logical Backup Device for a Tape Drive (SQL Server Management Studio)
- How to: Delete a Backup Device (SQL Server Management Studio)
- How to: Set the Expiration Date on a Backup (SQL Server Management Studio)
- How to: View the Contents of a Backup Tape or File (SQL Server Management Studio)
- How to: View the Data and Log Files In a Backup Set (SQL Server Management Studio)
- How to: View the Properties and Contents of a Logical Backup Device (SQL Server Management Studio)
Restore How-to Topics
- How to: Restore a Backup from a Device (SQL Server Management Studio)
- How to: Restore a Database Backup (SQL Server Management Studio)
- How to: Create a New Database From an Existing Database Backup (SQL Server Management Studio)
- How to: Restore a Differential Database Backup (SQL Server Management Studio)
- How to: Restore a Database to a Marked Transaction (SQL Server Management Studio)
- How to: Restore a Transaction Log Backup (SQL Server Management Studio)
- How to: Restore to a Point in Time (SQL Server Management Studio)
See Also
Other Resources
SQL Server Management Studio Tutorial
Backing Up and Restoring How-to Topics (Transact-SQL)
Backing Up and Restoring Databases in SQL Server