Manually Backing up Secret Server

To back up your Secret Server installation:

Your Secret Server instance may be running during this procedure.

  1. Navigate to the directory where Secret Server is installed.

  2. Copy the folder (holding the application) to your back up location.

  3. Open your SQL Server Management Studio.

  4. Right click the database your Secret Server is running on, and select Tasks > Backup.

  5. Click the Add button. You will be prompted to enter a file path.

  6. Make sure SQL Server has permissions for this location.

  7. Copy the resulting database backup file to your backup location.

You can also automate steps 2-4 using the command: osql -S myserver\SQLEXPRESS -E - Q "BACKUP DATABASE SECRETSERVER TO DISK = 'c:\backup\ss.bak'.