Detail step
1. Stop SCOM server service
a. On the Root Management Server, stop the OpsMgr Config Service and Opsmgr SDK service.
b. On all Management Servers, stop the OpsMgr Health Service.
2. On the old DW server, backup OpsMgrDW and take it offline
a. Backup OpsMgrDW, and ensure backup success.
b. Take offline OpsMgrDW.
3. On the new DW server, restore OpsMgrDW
a. Copying the backup to a local drive.
b. Restore the OperationsManagerDW database from backup.
4. Create service account in new DW
a. Use SQL Management Studio connect to the new Data Warehouse server.
b. Create a login for the OpsMgr SDK Service account, the Data Warehouse Action Account, and the Data Reader Account.
( or run sql
USE [master]
GO
CREATE LOGIN [CN001\OMSDKCSA] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
CREATE LOGIN [CN001\OMDRA] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
CREATE LOGIN [CN001\OMDWWA] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
)
5. Update login permission for SDK service account
a. In Microsoft SQL Server Management Studio, in the Object Explorer pane, navigate to Security and then expand Logins.
b. Right-click on the account that corresponds to the computer on which the SDK Service is. Select Properties.
c. In the Login Properties dialog box, in the Select a page pane, select User Mapping.
d. In the Users mapped to this login list, In the Map column, check the box that corresponds to the OperationsManagerDW database.
e. In the Database role membership for: OperationsManagerDW list, check OpsMgrReader.
f. Click OK to save your changes and to close the Login Properties dialog box.
6. Update login permission for Data Reader Account
a. In Microsoft SQL Server Management Studio, in the Object Explorer pane, navigate to Security and then expand Logins.
b. Right-click on the Data Reader Account.
c. In the Login Properties dialog box, in the Select a page pane, select User Mapping.
d. In the Users mapped to this login list, In the Map column, check the box that corresponds to OperationsManagerDW.
e. In the Database role membership for: OperationsManagerDW list, check OpsMgrReader.
f. Click OK to save your changes and to close the Login Properties dialog box.
7. Update login permission for Data Warehouse Action Account
a. In Microsoft SQL Server Management Studio, in the Object Explorer pane, navigate to Security and then expand Logins.
b. Right-click the Data Warehouse Action Account.
c. In the Login Properties dialog box, in the Select a page pane, select User Mapping.
d. In the Users mapped to this login list, In the Map column, check the box that corresponds to OperationsManagerDW.
e. In the Database role membership for: OperationsManagerDW list, check the following items: OpsMgrWriter and db_owner.
f. Click OK to save your changes and to close the Login Properties dialog box.
8. Configure the name of the new Data Warehouse server in DB
a. On the server that hosts the OperationsManager database, open SQL Server Management Studio and navigate to Databases, OperationsManager, and then to Tables.
b. Right-click dbo.MT_DataWarehouse, and then select Open Table.
c. Change the value in the MainDatabaseServerName_16781F33_F72D_033C_1DF4_65A2AFF32CA3 column to the name of the new Data Warehouse server.
d. Close SQL Server Management Studio to save your changes.
9. Configure the name of the new Data Warehouse server in DW
a. On the new Data Warehouse server, open SQL Server Management Studio and navigate to Databases, OperationsManagerDW, and then to Tables.
b. Right-click dbo.MemberDatabase table and select Open Table.
c. Change the value in the ServerName column to the name of the new Data Warehouse server.
d. Close SQL Server Management Studio to save your changes.
10. Update reporting server data source Data Warehouse Main
a. Use SQL Management Studio connect to the OpsMgr reporting service.
b. Open home, Right-click Data Warehouse Main select properties, select connection tab, update connection string to the new Data Warehouse server.
11. Start the OpsMgr SDK Service on RMS
a. On the Root Management Server, start the Opsmgr SDK service.
12. Confirm Data Warehouse Action Account
a. Open SCOM console -> Administration -> Security -> Run As account
b. Confirm if data warehouse action account is the same as the writerloginName column in the managementgroup table in data warehouse database
13. Start Service (Config, Health) on RMS and every MS
a. On the Root Management Server, start the OpsMgr Config Service.
b. On all Management Servers, start the OpsMgr Health Service.
