How to backup and restore Recon databases from SQL 2000, SQL 2005 SP2, Microsoft SQL 2008 SP2, SQL Express 2008 R2 and POSTGRE

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

SQL 2000 Backup

1. Launch Enterprise manager and connect to server.
2. Select the database you want to backup and right-click on it.
3. Select All Tasks > Backup.
4. Select Database Complete backup
5. 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).
6. (Conditional) If you are upgrading a previously installed instance of PlateSpin Recon, the Upgrade confirmation dialog box is displayed. Click Yes to continue.
7. Select Overwrite existing media (Make sure that in previous item you have chosen new back file, not the existing one)
8. Click OK.

SQL 2005 SP2, MS SQL 2008 SP2, or SQL Express 2008 R2 Backup

1. Launch SQL Management Studio and connect to server.
2. Select database you want to backup and right-click on it.
3. Select Tasks > Backup.
4. Select Backup Type - Full.
5. 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).
6. Click Options in the list to the left.
7. Select Overwrite All Existing Backup Sets (Make sure that in previous item you have chosen new back file, not the existing one).
8. Click OK.

POSTGRE Backup

1. Launch PgAdmin III and connect to server.
2. Select database you want to backup and right-click on it.
3. Select Backup.
4. Specify the filename for the backup. Ensure that file does not exist.
5. Accept the default values for all options.
6. Click OK.
7. When the backup process is complete, Click Done.

SQL 2000 Restore

1. Launch enterprise manager and connect to server.
2. Make sure that you do not have database with the same name of the database you want to restore.
3. Right-click the Databases node in the tree to the left.
4. Select All Tasks > Restore Database.
5. Specify a new name for the database in the Restore As Database field.
6. Select Restore From Device.
7. Click Select Devices.
8. Click Add.
9. Select the file that contains the backup you want to restore.
10. Click OK.
11. Select Restore backup set: Complete.
12. Click the Options tab and make sure that the location where the database files will be created is correct. Change the location if necessary.
13. Click OK.

SQL 2005, 2008 SP2, or  SQL Express 2008 R2 Enterprise Database Restore

1. Launch SQL Management Studio and connect to server.
2. Make sure that you do not already have a database with the same name as the database you want to restore.
3. Right-click on Databases node in the tree to the left.
4. Select Restore Database.
5. Specify a new name for the database in the To Database field.
6. Select From Device.
7. Click the … button.
8. Click on Add and select file that contains the backup set you want to restore. Only one set should be selected.
9. Click OK
10. Select the check box next to the database backup set you want restore. Only one set should be selected.
11. Click Options item in the list to the left.
12. Make sure that the locations where the database files will be created is correct. Change the location if necessary.
13. Click OK.

POSTGRE Restore

1. Launch PgAdmin III and connect to server.
2. Right-click on Databases node and select New Database.
3. Create database in the correct table space with default parameters and new name.
4. Right-click the database and select Restore.
5. Select the name of the file that contains the backup you want to restore.
6. Click OK.(Several messages are displayed, ending with Process returned exit code 1.)
7. Click Cancel.