How to back up an SQL Database in SQL Server 2012

[G.W.Green]

Here are the steps to backup your SQL database in SQL Server 2012.

1. Close SellerDeck on all machines
2. Open 'Microsoft SQL Server Management Studio'
   
   
   
   
3. Expand 'Databases'
4. Right click on the database and go to 'Tasks | Back Up'
   
   
   
   
5. This will open the 'Back Up' window. In the General tab, choose 'Backup Type' as Full.
   For 'Destination' choose Disk.
   If you see anything in the list, highlight it and click ‘Remove’
   Then click ‘Add’ to choose the backup location, and choose a unique name
   
   
   
   
   
   
   
   
6. Once you have chosen the backup destination, highlight it and then click 'Options' in the main backup window.
   
   Choose ‘Overwrite all existing backup sets’ and press OK
   
   
   
   
7. You will then get a message saying the backup was successful
   
   
   
   
8. Do the same for the shipping database
   
   
   
   
9. You will now have two .bak files in the destination you specified