Database Backup

There are several methods to backup your database:

Recommended Method TO BACKUP – Use Microsoft SQL Management Studio

Recommended Method TO MOVE DATABASE TO NEW SERVER – Use Microsoft SQL Management Studio

=======================================================
THE MOST IMPORTANT STEP – DO THIS FIRST!!!!
=======================================================

[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!

(Note: your database password can be found in \Documents\CRS\Database\database.xml file).

=======================================================

Recommended Method TO BACKUP YOUR DATABASE – Use Microsoft SQL Management Studio

[1] Download and install MS SQL Management Studio (free download via Microsoft website)

[2] Run Microsoft SQL Server Management Studio and connect to your instance of CRS:

Above: Connect to your instance of SQL Server

[2] Backup your database:

  1. Expand Databases – you will see CRS database.
  2. Right Click CRS and select Tasks->Back up:

    Backup your CRS SQL database

  3. Copy the database files from the backup to somewhere safe!

[3] Restore your database doing the same in reverse – instead select Restore:

  1. Connect to the CRS instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
  2. Expand Databases. Select CRS database.
  3. Right-click the CRS database, point to Tasks, and then click Restore.
  4. Click Database, which opens the Restore Database dialog box.
  5. On the General page, the name of the restoring database appears in the To database list box. To create a new database, enter “CRS” name in the list box.
  6. To specify the source and location of the backup CRS database click one of the following options:
    • From device
      Click the browse button, which opens the Specify Backup dialog box. In the Backup media list box, select one of the listed device types. To select one or more devices for the Backup location list box, click Add.
      After you add the devices you want to the Backup location list box, click OK to return to the General page.
  7. Click File option.  Tick – “Relocate all files to folder”  (this will copy the CRS database to the SQL Server default location).
  8. Click OK to restore database.

If you get an error it is usally because the old CRS files are still physically located in the same folder you are trying to restore the backup database to.  Rename the old database files:
C:\Program Files\Microsoft SQL Server\MSSQL11.CRS\MSSQL\DATA\CRS.mdf and CRS_Log.ldf and try the restore again.

 

Recommended Method TO MOVE DATABASE TO NEW SERVER – Use Microsoft SQL Management Studio

Backup your database as per the steps above.  DO NOT PROCEED UNTIL YOU HAVE COMPLETED THIS STEP!

[1] Download and install MS SQL Management Studio (free download via Microsoft website)

[2] Run Microsoft SQL Server Management Studio and connect to your instance of CRS:

Above: Connect to your instance of SQL Server

[3] DETACH your database:

  1. Expand Databases – you will see CRS database.
  2. Right Click CRS and select Tasks->Detach:

    Drop any existing connections to the database that may be active from other workstations running CRS

[4]  Installed CRS Full.exe on the new machine – this will set up a new empty database.

[5] Download and install MS SQL Server Management Studio (free download via Microsoft website) on the new machine.

[6] Copy the physical database files from the old machine to the new machine located in:
C:\Program Files\Microsoft SQL Server\MSSQL11.CRS\MSSQL\DATA\CRS.mdf and CRS_Log.ldf

[7] Run MS SQL Server Management Studio, right click Databases->Attach then select CRS.mdf file from step above

[8] Run CRS and it should pick up your old database.