How do I backup my database?

There are several methods to backup your database:

Method 1 – Copying the physical database files

Method 2 – 3rd Party Software

THE MOST IMPORTANT STEP IS THIS:

[1] Backup your CRS data and templates which can be found at:

C:\Users\[Your User]\Documents\CRS\

DO NOT PROCEED UNTIL STEP [1] IS COMPLETED!

[2] Backup your CRS database.  

For SQL backup

DO NOT PROCEED UNTIL STEP [2] IS COMPLETED!

You can manually make copies of your database files by stopping the SQL Server (CRS) service (Run->services.msc) then go to “C:\Program Files\Microsoft SQL Server\MSSQL11.CRS\MSSQL\DATA” and physically copy CRS and CRS_log files. Once copied, restart the CRS service again.

Please also ensure you backup your c:\User\Documents\CRS\ folder which contains your database connection file, license file and templates.

We also recommend the following SQL Backup software which is free: sqlbackupandftp.com [1] but unable to offer support for this software.