随着MP和被管理Agent数量的增加，Data Warehouse的数据增长很快，所以迁移Data Warehouse一方面是为了获得更好的处理性能，另一方面是为了获得更好的存储能力。基本上我把迁移分成了15步，第1步和第15步可以省略，其它步骤均有详细说明。对于120G大小的数据，4CPU*2.83GHz, 8G内存的环境预计所用时间为2.5~3小时。
Detail step
1. Stop SCOM server servicea. 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 offlinea. Backup OpsMgrDW, and ensure backup success.
b. Take offline OpsMgrDW.
3. On the new DW server, restore OpsMgrDWa. 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 Accounta. 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 Maina. 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.
