There might be cases where you face difficulties while implementing licensing changes, upgrades, or attempting to make changes directly to the database. These situations require you to restore your FogBugz database from a backup to resolve them.
- Access the FogBugz Database environment.
- Open Microsoft SQL Server Management Studio, and navigate to Databases.
- Right-click on the Databases, and click Restore Database.
- In the Source section, select Device, and click the browse button.
- Click Add in the Select backup devices window.
- Browse to the location of your recently restored flat files. Choose the Full backup file which should be the first backup file in the list:
- Click OK in the Select backup devices window.
- Click OK. In the Destination section, select the database to which you wish to restore, and in the Backup sets to restore section, select the backup file you added in step 6.
- In the left pane, click Options, and select the following:
- In the Restore options section, check the Overwrite the existing database (WITH REPLACE) option and leave other options unchecked.
- In the Recovery state field, select RESTORE WITH NORECOVERY.
The following description for this option is displayed:
Leave the database non-operational, and do not roll back uncommitted transactions. Additional transaction logs can be restored.
- Click OK to perform the restore and wait for its completion.
- Confirm the restored database is in the Databases list.
After logging into the system or inspection of the database, the old data from the backup should be displayed.