Knowledge Base

Where are the SQL Response data files stored?

Category: Security & data protection
Date: 08 Jun 2009
Product: SQL Response
For backup, recovery, and security assessment reasons, it may be advantageous to know the location of the physical files that SQL Response uses for its' alert repository.

Here is a list of the SQL Response data files:

Repository Files

All files are kept in the All Users profile (pre Vista) or Program Data (Vista onwards)
[All Users]\Application Data\Red Gate\SQL Response 1

Repository configuration, alerts & recommendations
.\DB_0\SQLResponse_Main0.rdb

Per server state data used by the SQL & Server monitors
.\DB_[n]\SQLResponse_Data[n].rdb

Alert details files (gziped XML)
.\[nn]\[nn]\[nn]\[nn].incident

SQL Trace files
.\[nn]\[nn]\[nn]\[nn].trace