How To Backup Your SQL Database For Support

How To Backup Your SQL Database For Support

Getting Your SQL Database Backup

Sometimes the CurrentWare support team may request a copy of your database via a backup. This is usually rare and when handling your database the team follows a strict security protocol to ensure all data is secure.
The best way to get a backup would be to use SQL Server Management Studio.

You will need to take a backup with SQL Management Studio.  SSMS can be downloaded Here.
Once installed use the following steps to take a backup of the SQL database.
  1. Launch SSMS (SQL Server Management Studio)
  2. Connect to your SQL Database Engine.  If using the default SQL Express you should see a prompt similar to the below image and can click the Connect button.
  3. In the Object Explorer pane expand the Databases folder by clicking on the plus to the left of the folder.
  4. Right-click on the SQL database for Currentware, (The default database name is CWNPSQL) select the Tasks menu item, and then select Back Up... from the sub-menu.
  5. The Back Up Database window should look like the below screenshot.  Take note of the path in the Destination section as this will be the path and filename for your backup. 
  6. Click on OK to begin the backup.
  7. When the backup completes successfully you will get the following message and your backup file will be in the path noted previously.  
  8. Navigate to the destination path from the backup and right-click > send to > compressed (zipped) folder for the latest .bak file for your database.
  9. Upload the zipped folder to the logs location as requested by support