This document will show you how to use SQL Server Management Studio to backup a database.
To perform the steps in this document SQL Server Management Studio is required.
When working with a database on a server managed by an IT department, ensure any backup policies are adhered to before following the steps below.
| Step 1 | Start SQL Server Management studio and select the server to which you want to connect. | |
|---|---|---|
| Step 2 | Once you are connected, you should see a screen similar to the one on the left. | |
| Step 3 | Expand the "Databases" folder in the "Object Explorer" and select the database you wish to backup. | |
| Step 4 | Right click the selected database, open the "Tasks" submenu, and choose the "Backup..." option. | |
| Step 5 | A dialog will appear with some options. Make sure you are on the General tab.
| |
| Step 6 | Within the Backup Options tab ensure that the expiry option is set to "After 0 days" . | |
| Step 7 | When you have performed the steps above, your dialog should resemble the one on the left. Click "Add.." to the right of the destination list. | |
| Step 8 | Select the File Name option and click the button to the right of the destination field ("...") In the Locate Database Files dialog, browse to the location to store the backup and in the File Name field enter a name for the backup followed by .Bak For example MySharedGroup.Bak If you are connected to a remote server, the backup location will be on the server, not your local machine. Click "OK" | |
| Step 9 | To start the backup, click "OK" | |
| Step 10 | When the backup is complete, a message similar to the one on the left will appear. |
| Knowledge Base Article Ref: | KB13022701 |
|---|