FAQs

Database

You will receive an email containing your online hosting details for your new database that will contain the following items:

——————————————————————–

Hostname: This is the new database host address

Database: The name of the database

User ID:   The login name of the database

Password:  The database password

——————————————————————–

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!

Instructions to change to a new database

Option 1 – Via CRS Settings

Option 2 – Manual Method

Option 1  – Change Database location via CRS Settings

Start CRS and go to Settings->Database tab.  Next click the Database Connection button.

The Database Wizard page will open where you can specify the new values as per the email.

Please enter Hostname, Database, User ID and Password exatactly as you find them in the email.  Simply copy and paste these values.

Click the TEST CONNECTION [1] button and the connection should go GREEN

IMPORTANT: IF THIS IS A NEW DATABASE YOU WILL NEED TO SPECIFY THE DATABASE STRUCTURE BY CLICKING THE REMAINDER BUTTONS (3, 4 AND 5).  BUTTON 2 CAN BE INGNORED IF USING A ONLINE DATABASE AS THIS ONLY CHECKS YOUR LOCAL MACHINE FOR AN INSTALLED SQL SERVER INSTANCE.

Instructions to change to Online Database

[2] Open “database.xml” using notepad which is located at:

C:\Users\[Your User]\Documents\CRS\Database\database.xml

In order to start using your online database you need to make a change in your database.xml which can be found at:

Please delete the contents of the file and replace with the following:

============= COPY BETWEEN THIS LINE =============

Data Source=79.170.40.192;Initial Catalog=mssql0_LaptopGeek_1;Integrated Security=False;User ID=mssql0_LaptopGeek_1;Password=crs5%8>hTr;Pooling=True;Max Pool Size=200;Connect Timeout=30
================== AND THIS LINE ==================

If you have any questions regarding license renewal, please look at our FAQs or reply to this email.

Kind Regards

Paul
Computer Repair Shop Software,

Category: 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.

Category: Database

Load More