Revert to a Previous SQL Database | Bosch Appliances D5500CU

RPSMaintenance en 55

6.3	Revert to Previous RPS Installation After SQL Upgrade
6.3.1	Revert to a Previous SQL Database

	NOTICE!
	The following procedure assumes that you used SQL Management Studio to back up the
	previous SQL database (creating a .bak file), and that the Database directory containing the
	.dat files was also backed up.

	1.	Select Control Panel > Add or Remove Programs, then uninstall the existing RPS
		installation.
	2.	Restart the PC.
	3.	Ensure that the backed up database is not inside the RPS directory, then delete the RPS
		directory.
	4.	Open SQL Server Management Studio or SQL Server Management Studio Express.
	5.	Right-click on the RPS database, then select Tasks > Restore > Database

6.The Restore Database dialog opens. Under Source for restore, select From device, then click ....

Bosch Security Systems, Inc.

Installation Guide

4998141259 12 2011.10

Image 55

Bosch Appliances D5500CU manual Revert to Previous RPS Installation After SQL Upgrade, Revert to a Previous SQL Database

Contents

RPS Page Table of Contents Index MaintenanceLog into RPS RPS Operation and Control Panel Account Notes 1Trademarks 1LegalSoftware License Agreement En Legal RPS Release Notes IntroductionRPS Minimum System Requirements Minimum 500 MHz Minimum System Requirements for SQL Express OnlyBrowser Minimum System Requirements for RPS and SQL Express on a RPS and SQL Express on the Same PC Minimum RequirementsPC with Vista Bit 1 GB PC with WindowsBit 2 GB Install RPS with a Local SQL Database Install RPS1Overview Install RPS en Use an Existing SQL Instance, Create a New SQL Instance, Prepare the Installation of the SQL Database and RPS RPS Install the SQL Database Install the SQL Database and RPS RPS En Install RPS RPS Install RPS with a Network SQL Database Then click Next En Install RPS Install the SQL Database and RPS En Install RPS RPS En Install RPS Use an Existing SQL Instance En Install RPS Create a New SQL Instance User Name sa Password sql12345 RPS Database Name RpsdbSQL Instance Name Boschsql Generate the RPSInstallation.ini File Automatic Installation of RPSOverview Customize the RPSInstallation.ini File Use the RPSInstallation.ini File Known Issues View the Installation Log File Upgrade RPS with a SQL Database Upgrade RPSBefore You Upgrade RPS Select Start Run… Upgrade RPS Upgrade RPS en En Upgrade RPS RPS En Upgrade RPS RPS with a SQL Database, page 33 for upgrade instructions Upgrade RPS with a Microsoft Access Database Prepare the Upgrade for a Local SQL Database Prepare the Upgrade for a Network SQL Database En Upgrade RPS Upgrade RPS En Upgrade RPS RPS 3Share the SQL Database Automatic Integration Select ConfigSystemFile LocationsClick Upgrade Database Integrate the RPS Database Files into the SQL Database Create a New Database 3Upgrade from RPS 5.11 or LowerConversion Log File First Time Log-In Log into RPS Change the Password Set Security Levels by Panel Type for Networked Users Maintenance Modify RPS Modify, Repair, or Remove RPS 2Repair RPS 3Known Issues 4Remove RPS Revert to a Previous SQL Database Revert to Previous RPS Installation After SQL Upgrade En Maintenance RPS En Maintenance RPS Revert to a Microsoft Access Database Select Config System File Locations Recover Old Database Files Select Config System Switch from a Client to a Network Installation RPS Back Up the SQL or SQL Express Database Click the Protocols for Sqlexpress node Install SQL Server Management Studio ExpressRight-clickSQL Server Browser and select Properties En Maintenance RPS En Maintenance RPS General Operation Installation and AdministrationRPS Operation and Control Panel Account Notes RPS Notes Series Control Panel Account NotesD6412/D4412 and DS7240/DS7220 D8112 D7024 and DS9400D9112B1, D7212B1 6DS7400XiV4-EXP Numerics Index RPS En Index Page Bosch Security Systems, Inc