Was this article helpful?
Create a Backup of the Syrinx Database
Creating a Backup of the Syrinx Database allows you to keep a copy of it in a secure location. This means that if there are any issues with the useable Database, then you can restore the backup to ensure there is minimal data loss.
To take a Backup, you will need to connect onto your Syrinx Server Machine, and then load the Syrinx SP Database Administration Program, which can be found in the Start Menu > All Programs > Syrinx SP.
When you load the program, you will be asked to log in. You will need to set the Database name to Master. You will then have to use the Username of sa and the Password that links to that account.
Once logged in, there will be a Backup option on the Main Menu.
This will load up a Window for you to select the Database to Backup and the Location to save it to.
In the Database to back up drop down, you can select which Database you want to back up. If you only have one Database it will be set to that automatically.
You will also be able to select the folder location of where you want the Backup to be created. By default, this is set to C:\SQLDataSP\Backup. There is also the option to change the name of the Backup, however you will need to ensure you leave the file extension as .bak.
*Please note, if you try to Backup to a Network location, you will need to ensure the User that is running the SQL Server Service has access to this location.
Using the Backup Now will create an instant Backup to the location specified. The window will say ‘Backing Up – Please Wait…’ whilst the Backup is taking place.
If a Backup already exists in the folder you are attempting to back up to, it will provide you with a message asking if you wish to overwrite the file. Select Yes and it will create the Backup, select No and it will go no further.
Once the Backup is complete, you will get a message advising you of the file location and name, and the size of the file created.
There is also the option ‘Create Batch File to do Backup’
If you use this option and press OK, you will get the below message.
Once you click OK on this message, you will get a window allowing you to select the location you want to save the Batch file to.
*Desktop folder is always a good option at this point as it is easy to get to and allows you to test the file works. It can be moved at a later date if necessary.
After selecting to location pressing OK, You will then be prompted for connection details to your database server:
After entering the connection details and pressing OK, it will create the Batch file for you. It will be called BackupHire.bat:
When you double click on the Batch file it will attempt to run the Backup. It will save the Backup to the location you specified in the file path earlier.
You can also set the Batch file up within Windows Task Scheduler to run at specified times creating an Automatic Backup. This saves needing to connect onto the Server and run it every time.