Backing up and Restoring databases is not the responsibility of ClickHome staff. However during some Support or Implementation activities we will take a backup. Rough instructions for performing a Simple Copy only backup are below

  1. Open SQL Management Studio
  2. Open Object Explorer
  3. Connect to your Instance
  4. Expand Databases
  5. Right hand click on the database > Tasks > Back Up
  6. Confirm Database is selected correctly
  7. Confirm Backup type is Full
  8. Tick Copy only Backup
  9. Confirm Backup Component is selected Database
  10. Under Destination at the bottom, choose Disk > Click Add and choose a location to save to and a Filename (ensure has .bak at the end) > Click OK
  11. Click OK to begin the Back up.


Some Suggested Links on Backup methodology are below:

MSDN Overarching Backup Article: https://msdn.microsoft.com/en-us/library/ms187048.aspx
SQL Authority Blog: http://blog.sqlauthority.com/2012/12/18/sql-server-select-the-most-optimal-backup-methods-for-server/