How to Backup/Restore Spotlight on Messaging (SOM) Microsoft SQL database and configuration setti (4267657)

N/A

Perform the Backup andRestore asstated below.

A. Backup Microsoft SQL Server 2005 SOM database using Management Studio

1. Open SQL Server Management Studio.
2. Connect toMicrosoft SQL Server database.
3. Right-click on the SOM database and select All Tasks | Back Up.
4. Under Backup type, select Full.
5. Under Destination, click Add.
6. Enter the path and file name for the backup file.
7. Click OK.
8. Review the settings for the backup.
9. Click OK to begin the backup.
10.Locate the backup filesand put in a safe location

Note: The instructions above will create a complete backup of theSOM Database. This is the recommended method to ensure that all data is backed up.

B. Restore Microsoft SQL Server 2005 SOM database using Management Studio

1. Open SQL Server Management Studio.
2. Connect toMicrosoft SQL Server database
3. Right-click on the SOM database and select All Tasks | Restore | Database
4. Under To Database type, select SOM Database.
5. Under From Device, click the ellipsis button (...)
6. Under Backup Media, Select File, click Add
7. Specify the path and file name for the backup file.
8. Click OK.
9. Review the settings for the backup.
10.Click OK to begin the restore.

C. Backup SOM Configurations

1. Locate all of the .stx, .scx & .stc files on the system where the SOM product is installed (by defaultunder C:\Program Files\Quest Software\Spotlight\Console\Templates)

2. Save the files to tape\disk or other safe location

D. Restore SOM Configuration

After reinstalling the product, please replace the current files with the backed up configurations done on instruction C above.

N/A