How to Move the Audit Collection Database
Updated: May 13, 2016
Applies To: System Center 2012 R2 Operations Manager, Operations Manager for System Center 2012, System Center 2012 SP1 - Operations Manager
After the initial deployment of System Center 2012 – Operations Manager, you might need to move the Audit Collection (OperationsManagerAC) database from one Microsoft SQL Server-based computer to another.
This procedure requires Microsoft SQL Server configuration. You need to back up a database, restore a database, and add a new Login. For more information, see SQL Server documentation.
Use the procedure below to move the ACS database to a different server.
To move the ACS database
On the original Audit Collection database server, stop Operations Manager Audit Collection Service.
Use Microsoft SQL Server Management Studio to create a full backup of the ACS database. The default name is OperationsManagerAC. We also recommend you back up the master database.
For more information, see Create a Full Database Backup (SQL Server).
On the new SQL server, copy the backup file to a local drive or map a local drive to the folder that contains the backup file.
Optionally, on the original server that hosts the ACS database, delete the ACS database.
On the new server, use Microsoft SQL Server Management Studio to restore the ACS database that you previously backed up.
For more information, see Restore a Database Backup (SQL Server Management Studio).
On the new ACS database server, use SQL Management Studio to create a login for the ACS server, as follows:
In SQL Server Management Studio, navigate to Security and then to Logins. Right-click Logins and select New Login.
In the Login name box, enter the ACS server (the system on which the ACS service runs) in the format domain\computername$.
Under Select a page, click User Mapping.
Under Users mapped to this login, select the ACS database (default: OperationsManagerAC), and then, under Database role membership for, select db_owner.
Click OK to save your new account.
For more information, see Create a Login.
Update the registry on ACS server to refer to the new ACS database server.
Before editing the registry, follow your organization’s backup policies with regard to the registry.
Log on to the management server with Administrator permissions.
Click Start, select Run, type regedit in the Open box, and then click OK to start Registry Editor.
Under HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\OpsMgrAC, double-click the name Server, and then change the value to the hostname of the SQL Server-based computer now hosting the ACS database, and then click OK to save your change.
If you are using a named instance of SQL Server, be sure to use the ServerName\Instance name format.
Close the Registry Editor.
On the server on which the ACS service is running, start Operations Manager Audit Collection Service.