Learn how to back up your OMS database manually.
It is important to perform backups on your OMS database to ensure your data is safely stored in the event of data corruption, incorrect data, or a potential cyberattack.
This article details how to back up your OMS database manually, which is a task you may choose to run periodically or before a system update.
Master System cannot diagnose or investigate individual configurations in the event an issue occurs during backup. Master System does not provide a backup and restore service.
Please consult your IT administrator or team for investigation or for further information.
This does not apply for OMS Cloud configurations.
Backing up OMS:
- Open SQL Server Management Studio and connect to the SQL Server that contains the OMS data.
- Select the database that contains OMS. This may be called "omsdata", "apwdata", "shwdata", or another variant. If you do not know which database contains your OMS data, please contact us.
- Right click your database and click on Tasks --> Backup...
- On the Back Up Database window, make sure the Backup type is "Full".
- Under "Destination" you are provided the path of the last backup. If you want your database to be backed up in a different place, click the path and click "Remove". This will not delete your previous backup.
- Click "Add" to open the backup destination you wish your database to be backed up to.
- Under Select Backup Destination, enter a File Name. Make sure to add a .bak extension and the destination is different than the default location. The default path for backups is "C:\Program Files\Microsoft SQL Server\<SQL version>\MSSQL\Backup"
- Click OK once you have selected a location for your backup.
- Click OK to close the database file window.
- Click OK to start the backup.
- Once the database starts backing up, a progress icon will display on the bottom left corner, and a "Completed Successfully" message will display when it is complete.