SQL Response
Latest version: 1.3
Notes & articles
Migrating your Alert Repository from Windows 2000
This article explains how to move your Alert Repository from a computer running Windows 2000 to another computer. Windows 2000 is no longer a supported operating system for running the SQL Response Alert Repository.
After moving your Alert Repository, all your alert data will still be available. You will not lose any information about any of your monitored SQL Servers.
To move the Alert Repository
- Close down any SQL Response clients that are running.
- Stop the SQL Response Alert Repository Service
- From the Control panel, select Administrative Tools, and then select Services.
- Right-click the entry for SQL Response Alert Repository Service and select Stop.
- Copy the Alert Repository data files to the new computer
The folder used to store all the Alert Repository data files was specified when you first installed the Alert Repository.
- Default for Windows 2000, XP, 2003:
C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Response 1 - Default for Windows Vista, 2008:
C:\ProgramData\Red Gate\SQL Response 1Copy all the contents of the data folder (including all subfolders) to a suitable folder on the target computer.
- Default for Windows 2000, XP, 2003:
- Restart the SQL Response Alert Repository Service
- From the Control panel, select Administrative Tools, and then select Services.
- Right-click the entry for SQL Response Alert Repository Service and select Start.
- Start the SQL Response client and then connect to the Alert Repository
- Deactivate the SQL Server licenses
Right-click in turn on each SQL Server in the Servers to show area, and select Deactivate Server License.
- Uninstall the Alert Repository on the original computer
Use Add/Remove Programs to remove SQL Response.
- Install the Alert Repository on the new computer
In the SQL Response client, on the Alert Repository menu, select Alert Repository Setup.
When you enter the location for the Alert Repository data folder, ensure you specify the folder into which you copied the original repository data.
- Connect to the new repository with the SQL Response client
Right click in turn on each SQL Server in the Servers to show area, and select Activate Server License.
Was this article helpful?
What does SQL Response monitor?SQL Response
- Troubleshooting Computer Unreachable and Access Is Denied Error Messages
- SQL Response Security Setup
- Upgrading from Version 1.0 to 1.1 where the SQL Response Client and Alert Repository exist on the same machine
- Moving your Alert Repository Data
- Licensing SQL Response on a clustered SQL Server
- Server licenses may show "trial period has expired"
- How do I use the SQL Response client across domains?
- Where are the SQL Response data files stored?
- SQL Response client not connecting to Alert Repository
- The alert details are not recorded and SQL Response reports "Alert is still being written" when viewing an alert or multiple alerts
- Error when connecting to the Alert Repository using Windows 7
- Alert Repository transferring large amounts of data from the SQL Server
- Log files
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Response
- Migrating your Alert Repository from Windows 2000
- Tips for configuring SQL Response in your network environment
- SQL Response release notes - version 1.xx
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
