Back up and restore a PlayoutONE database

You may be required to restore a SQL database backup at some point if you have accidentally lost PlayoutONE data and want to restore your database to a previous point in time, or if you are moving your database to a new computer. To restore a backup, follow the instructions below:

Backing up your database

This can be achieved by finding your latest backup in the SQL_Backups folder, located in your data folder (usually C:\PlayoutONE\Data).

or 

• Open PlayoutONE's SQL Database Tool located in C:\PlayoutONE\SQL_Configuration
• Choose Backup from the three options.
• Select your database (usually PlayoutONE_Standard) from the dropdown list. 
• Click Backup. 

The backup will then be created in "C:\MsSQL"

Restoring a backup

• Ensure all PlayoutONE applications are closed 
• Open PlayoutONE's SQL Database Tool located in C:\PlayoutONE\SQL_Configuration
• Click Restore from the three options.
• Select the database to overwrite from the dropdown list (usually PlayoutONE_Standard) or create a new database by typing the name of the new database.
• Select your backup file.
• Click Restore.