Environment
NetIQ PlateSpin Recon
Situation
This article provides instructions on how to backup and restore the Recon databases from a SQL 2000, SQL 2005 SP2, Microsoft SQL 2008 SP2, SQL Express 2008 R2 and PostgreSQL Server.
Recon stores all inventory and monitoring data in either a SQL 2000, SQL 2005 SP2, Microsoft SQL 2008 SP2, SQL Express 2008 R2, or PostgreSQL Server database.
NOTE: YOU MUST SHUTDOWN ALL CLIENTS AND STOP THE POWERRECON SERVICES PRIOR TO BACKING UP/RESTORING
Resolution
SQL 2000 Backup
- Launch Enterprise manager and connect to server.
- Select the database you want to backup and right-click on it.
- Select All Tasks > Backup.
- Select Database Complete backup
- Select Disk destination, then specify new file location for backup (make sure that the device you selected have at least as much free space as database size).
- (Conditional) If you are upgrading a previously installed instance of PlateSpin Recon, the Upgrade confirmation dialog box is displayed. Click Yes to continue.
- Select Overwrite existing media (Make sure that in previous item you have chosen new back file, not the existing one)
- Click OK.
SQL 2005 SP2, MS SQL 2008 SP2, or SQL Express 2008 R2 Backup
- Launch SQL Management Studio and connect to server.
- Select database you want to backup and right-click on it.
- Select Tasks > Backup.
- Select Backup Type - Full.
- Select Disk destination then specify new file location for backup (make sure that the device you selected have at least as much free space as database size).
- Click Options in the list to the left.
- Select Overwrite All Existing Backup Sets (Make sure that in previous item you have chosen new back file, not the existing one).
- Click OK.
POSTGRE Backup
- Launch PgAdmin III and connect to server.
- Select database you want to backup and right-click on it.
- Select Backup.
- Specify the filename for the backup. Ensure that file does not exist.
- Accept the default values for all options.
- Click OK.
- When the backup process is complete, Click Done.
SQL 2000 Restore
- Launch enterprise manager and connect to server.
- Make sure that you do not have database with the same name of the database you want to restore.
- Right-click the Databases node in the tree to the left.
- Select All Tasks > Restore Database.
- Specify a new name for the database in the Restore As Database field.
- Select Restore From Device.
- Click Select Devices.
- Click Add.
- Select the file that contains the backup you want to restore.
- Click OK.
- Select Restore backup set: Complete.
- Click the Options tab and make sure that the location where the database files will be created is correct. Change the location if necessary.
- Click OK.
SQL 2005, 2008 SP2, or SQL Express 2008 R2 Enterprise Database Restore
- Launch SQL Management Studio and connect to server.
- Make sure that you do not already have a database with the same name as the database you want to restore.
- Right-click on Databases node in the tree to the left.
- Select Restore Database.
- Specify a new name for the database in the To Database field.
- Select From Device.
- Click the … button.
- Click on Add and select file that contains the backup set you want to restore. Only one set should be selected.
- Click OK
- Select the check box next to the database backup set you want restore. Only one set should be selected.
- Click Options item in the list to the left.
- Make sure that the locations where the database files will be created is correct. Change the location if necessary.
- Click OK.
POSTGRE Restore
- Launch PgAdmin III and connect to server.
- Right-click on Databases node and select New Database.
- Create database in the correct table space with default parameters and new name.
- Right-click the database and select Restore.
- Select the name of the file that contains the backup you want to restore.
- Click OK.(Several messages are displayed, ending with Process returned exit code 1.)
- Click Cancel.