Installation Guide
.
44
Installation Guide for Cisco Unified Contact Center Management Portal 8.0(1)
In most cases the .bak file is sufficient to restore the database, but if this fails you will
need to restore from the data files.
Back these up as described below:
1. Right-click Portal and select Detach database. This ensures that the data files
are in a stable state for copying.
2. Manually copy the data files to a suitable location.
In a similar fashion, back up the ReportServer databases:
1. Run the command services.msc.
2. Stop the ReportServer service.
3. Using the SQL Server Management Studio, back up the ReportServer and
ReportServerTempdb databases.
4. Detach the ReportServer and ReportServerTempdb databases.
5. Save the data files to a suitable location.
6. In the Enterprise Manager, attach the ReportServer and ReportServerTempdb
databases again.
7. Run services.msc and restart the ReportServer service.
Uninstalling Microsoft SQL Server 2000
1. Go to Start > Control Pan
el > Add or Remove Programs. The Microsoft SQL
Server 2000 programs must be uninstalled in the following order:
• Microsoft SQL Server2000 ReportServer Enterprise Edition (restart after
uninstallation if prompted to do so).
• Microsoft SQL Server2000 Analysis Services (if present).
• Microsoft SQL Server2000
2. Restart the computer.
Installing Microsoft SQL Server 2005 Standard Edition
1. Insert the CD for Microsoft SQL Server 2005 Standar
d Edition and install as
normal.
2. Install Service Pack 3.
3. Restart the computer.
Restoring the Databases
The databases
must now be manually restored from the backups made earlier.
1. Go to Start > All Programs > Microsoft SQL Server> Management Studio.
2. Click the Restore Database option.
3. Select the backup file (Portal.bak) to restore the Portal database.
Note If restoring any of the databases fails, it is also possible to restore the
database using the .mdf files previously backed up. This procedure is described
in its own section, below.
4. Run the services.msc command and stop the Microsoft SQL Server Reporting
Services ({MSSQLSERVER) service.