Why It’s Important to Take Regular Backups in Sage 200

In Office Life, Sage 200 by Holly Crompton

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…

  1. 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.

System Administration Companies Tab-backups

Screenshot of System Administration Companies Tab

  1. 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.

  1. 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.

  1. 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)

  1. 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)

To see more information on Backups or any other guides you may need, please click here! If you have any questions or queries, do not hesitate to contact our team!

Sage 200 Training CTA