Backup a database

This guide was created with Microsoft SQL Server 2008 in mind, but should work for any version of SQL Server. In this guide the database server is Server01 and the database is called Database9

1. Log on to Server01, open Microsoft SQL Server Management Studio and connect to default database instance.

2. Right-click on Database9 database and navigate to Tasks > Back Up…

3. Perform a full backup to a location of your choice. To assist with restoring the correct database I usually store the databases under a logical name, such as \Databasename\YYYYMMDDHHSS.bak .

4. Press OK to back up. Depending on the size of the database and other factors the process will take a few seconds to a few hours.

Posted in Guides Tagged with:

Leave a Reply

Your email address will not be published. Required fields are marked *