Wednesday, December 18, 2024
HomeDatabaseSQL Server 2005: How To Perform a Full Backup of a Database

SQL Server 2005: How To Perform a Full Backup of a Database

A full backup includes database files and locations as well as parts of the transaction log. A full backup is necessary, regardless of the backup strategy that is implemented, because all other backup types (differential and transaction log) depend on the having a full backup. To perform a full backup of your database, follow these steps:


1. Open SQL Server 2005 Management Studio.

2. Connect to the appropriate server.

3. Expand Databases.

4. Right-click the desired database, mouseover Tasks and select Back Up.

5. The Back Up Database window will appear.

6. Select the desired database from the Database dropdown.

7. Select Full from the Backup Type dropdown.

8. Under Destination, select an existing device or click Add to input a new one if no device has been added.

9. In the left pane, select Options.

10. Under Reliability, check the Verify backup when finished checkbox.

11. Click OK and the backup will start.

12. Once the backup is complete, a notification box will appear. Click OK to close the box. You have now performed a full backup of your database.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

LATEST REVIEWS

Recent Comments

error: Content is protected !!