SQL Backup
Revision as of 15:09, 1 November 2007 by Jason.Carmichael (talk | contribs) (New page: ==Description== This page will describe the steps necessary to perform a SQL backup. Backups should be created before making any major changes to a database to ensure you can restore them...)
Description
This page will describe the steps necessary to perform a SQL backup. Backups should be created before making any major changes to a database to ensure you can restore them if necessary:
Creating a backup with SQL 2005
- Log onto the server that you need to create the backup on
- Go to Start/Programs/Microsoft SQL Server 2005/SQL Server Management Studio
- The first prompt will ask you to which server to connect to. Supply the proper information and hit <Connect>
- Expand Databases
- Right-click the database you wish to backup
- Select Tasks/Backup