Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0

Restoring Secret Server from a backup

If you are restoring your Secret Server from a backup, here are the steps ...

Restoring the application

  1. Extract your zip of Secret Server to the physical file path that your virtual directory is pointing towards.

Restoring the SQL Server Database

(Option 1 - If your database and Secret Server installation are in the same locations use these steps )

  1. Open SQL Server Management Studio and connect.
  2. Right click Databases and click Restore Database.
  3. In the To database text box Enter the database name or select it from the drop down list.
  4. Select the from device radio button and browse to your database backup file.
  5. In the Restore Database window options make sure the Force Restore over Existing Database Check box is checked.
  6. Click Ok.
  7. Restart Internet Information Server (IIS) by running "iisreset" from the command line.
  8. Activate your licenses if required by going to the Licenses page.

OR

(Option 2 - If your database and or Secret Server installation are in different locations use these steps )

  1. Delete the database.config file from the secretserver folder.
  2. Restart Internet Information Server (IIS) by running "iisreset" from the command line.
  3. Point your web browser to the new instance of Secret Server.  You will then be taken to the web installer (this is because the database.config file is missing and it thinks you haven't installed yet)
  4. Open SQL Server Management Studio and connect.
  5. Right click Databases and click Restore Database.
  6. In the To database text box Enter the database name.
  7. Select the from device radio button and browse to your database backup file.
  8. In the Restore Database window options make sure the Force Restore over Existing Database Check box is checked.
  9. Click Ok.
  10. Disabled "Force SSL" if enabled in the new database and the certificate is not setup for the new server
    1. In SQL Server Management Studio run the following command: UPDATE [dbo].[tbConfiguration] SET ForceHttps = 0
  11. Go through the web installer to step 3
  12. On step 3 enter the new database credentials (new server location, username, password)
  13. Once past step 3, you are done - simply go to the home.aspx page (click the Secret Server logo)
    There is no need to go any further with the install/upgrade since the database.config has now been recreated with the new information.
  14. Activate your licenses if required by going to the Licenses page.

If you have any problems or questions, please contact support.

Article ID: 22, Created On: 1/30/2008, Modified: 12/12/2011