SQL Backup process

Published by

Posted on April 20, 2012

SQL Backup Process

1) Log into the Server using SQL Management Studio
2) Click the + sign next to databases to expand the list
3) locate the database and right click it. On the menu list select Tasks > Backups
4) Under Destination , take note of the existing destination. If ou wish to change it, select remove,
then add a new location. Select the new location and provide a database filename. please note the
database name must end with .bak

5) Once your new location is there , select ok and the backup will begin.