Reading Time: 3 minutes
Do you take regular backups?
Are your databases protected?
If you think about it, there are a number of ways data can become corrupt, lost or deleted… This is why backups are essential.
For instance… your computer crashes and you lose all the data you have been working on.
Or, alternatively you open a malicious email by accident, which corrupts all the files on your network drive that not only you use but your colleagues as well.
But have no fear! There is a way to protect your data.
What you need to know…
Everything within Sage 200 is backed up to an SQL database on your company server.
It is advised that before any key changes are made to your data, especially if you are commencing Year End or having a major Upgrade, that you take a backup.
This is so that if anything goes wrong, you are always covered and able to go back to the point when the backup was taken.
Depending on how big your database is, affects how long the backup could take.
How to do it using SQL Server Management Studio…
- Finding the Server
Before you are able to back up your company database, you will need to figure out which server the SQL database is kept on. This can be found in the company’s section of System Administration.
You may find that you don’t have permissions for this, if so you will need to contact your IT Team.
- Connecting to the Server
You will now need to access the server through SQL Server Management Studio which can be found in All Programs in the Start Menu.
This will have been installed when Sage 200 was put on your computer.
- Selecting the Company to backup
Once you are on the server, you can find the database you want to back up by expanding the Databases Tab which will list the databases on the server.
After you have found the database, right click select Tasks and Backup.
- Backing up the company
After clicking Backup, a window will pop up called Back Up Database.
In the destination section you must select and remove the current option so that you don’t overwrite any previous backups taken.
You then need to click on Add to select where you would like your backup to be created and click OK. (This file must end in .bak)
- Run the Backup
Once you have completed the steps above you are able to create your backup by clicking OK.
The backup will then be saved where you selected in the previous step.
Your Backup is now ready!
So if the unfortunate happens, you are able to restore your data. (Please note we accept no responsibility for any losses or damages caused by following the above suggested steps)
Holly is friendly,outgoing and at the heart of the itas team. She is our resident Excelerator and Iman expert, who loves solving those tricky cases! A bit of a film buff, Holly enjoys nothing more than a good trip to the cinema – popcorn and all!