Page History
...
- Use the SQL Server client tools to close any open connections to the SQLcompliance database.
- Use the SQL Server client tools to take the SQLcompliance database offline. If you cannot take the SQLcompliance database offline, stop the Collection Service.
- Use a tool such as IDERA SQL Safe to restore the SQLcompliance database using the appropriate backup file, including transaction logs.
- Use a tool such as IDERA SQL Safe to restore each event and archive database using the appropriate backup file, including the transaction logs. Each registered SQL Server instance has a corresponding event database. The number of archive databases depends on your archive preferences and your archive frequency.
- Use SQL Server client tools to bring the SQLcompliance database online.
Scroll pdf ignore | ||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Compliance Manageraudits all activity on your server. Learn more > >monitor, audit and alert on SQL user activity and data changes.IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
| |||||||||||||||||||||||||||||||||||||||||||
Newtabfooter | ||||||||||||||||||||||||||||||||||||||||||||||||||
|
Scroll Pagebreak |
---|