To take a backup of your database, do the following:
Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
Expand the Databases node in Object Explorer.
Right-click the database, hover over Tasks, and select Back up....
Under Destination, confirm the path for your backup is correct. If you need to change this, select Remove to remove the existing path, and then Add to type in a new path. You can use the ellipses to navigate to a specific file.
Select OK to take a backup of your database.
To restore database
Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
Right-click the Databases node in Object Explorer and select Restore Database....
Select Device:, and then select the ellipses (...) to locate your backup file.
Select Add and navigate to where your .bak file is located. Select the .bak file and then select OK.
Select OK to close the Select backup devices dialog box.
Select OK to restore the backup of your database.
Note: You may receive a message: 'the backup set holds a backup of a database other than the existing ORCHESTRATE_PLAY database'. To overwrite this prompt, you will have to go into options and select 'Overwrite the existing database (WITH REPLACE)'.
If you are a hosted customer who requires a restore, Please raise a new case online and reference the title of this article