Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This procedure is used if you need to restore the backed up database from a previous upgrade failure.

Tip: The following database restorations are based on Insula Software's recommended settings.

Restore Database - FworkSQLECM

  1. Open Microsoft SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio).
  2. Connect to the required server.
  3. Right-click on Databases and click Restore Database.... The Restore Database dialog will be displayed.
  4. In the To Database field, enter the Framework Database Name.

Example: FworkSQLECM

  1. In the From Device field, click the Browse button. The Specify Backup dialog will be displayed.
  2. Click the Add button. The Locate Backup File dialog will be displayed.
  3. Select the folder and file location of the backed up Framework database.

Example: A typical example of the backed up Framework database location is: \[fw folder]\Service\fwBackup_[Date]

  1. Click the OK button. The Locate Backup File dialog will close.
  2. Click the OK button. The Specify Backup dialog will close.
  3. In the Restore column, tick the backup to be restored.
  4. Select the Options tab.
  5. In the Restore the database file as list, click the Framework Database Name (i.e., FworkSQLECM) Browse button. The Locate Database Files dialog will be displayed.
    OR
    Use the default file location.
  6. Select the folder location where the database will be restored to.

Example: \[fw folder]\Data\DataMSSQL\

  1. In the File Name field, enter the file name: FworkSQLECM.mdf
  2. Click the OK button.
  3. In the Restore the database file as list, click the Framework Database Name Log (i.e., FworkSQLECM_log) Browse button. The Locate Database Filesdialog will be displayed.
    OR
    Use the default file location.
  4. Select the folder location where the database will be restored to.

Example: \[fw folder]\Data\DataMSSQL\

  1. In the File Name field, enter the file name: FworkSQLECM_log.ldf
  2. Click the OK button.
  3. Click the OK button. The database restoration will be performed.
  4. Close Microsoft SQL Server Management Studio.
  • No labels