how to reinstall data warehouse in production ?
I need to reinstall\recreate the data warehouse for existing environment... (I dont care to loose the information i got inside already)
what is the action points for this in order not to reinstall the reporting too ?
I need to reconfig the reporting ?
BTW, the reporting services installed on the RMS and the data warehouse on other server...
Thank you.
October 19th, 2010 10:19pm
Hey Sharon
The technet guide is for moving the DB
Is the DB in a failed state?
If you want to add a new DB to an exisiting environment I think you are going to have to perfrom a reinstall. I just had a read of the recovery guide and its only about restoring or moving
Here are the steps for a move
How to Move the OperationsManagerDW Database in Operations Manager 2007
For various reasons, it might be necessary to move the OperationsManagerDW database from its original server to another server.
Caution
This procedure can result in data loss if it is not performed correctly and within a reasonable length of time of the failure. Ensure that you follow all steps precisely,
without unnecessary delays between the steps.
The high-level steps to move the OperationsManagerDW database are as follows:
1.
Stop Microsoft System Center Operations Manager 2007 services to prevent updates to the OperationsManagerDW database during the move.
2.
Back up the OperationsManagerDW database to preserve the data that Operations Manager has already collected from the management group.
3.
Uninstall the current Data Warehouse component, and delete the OperationsManagerDW database.
4.
Install the Reporting Data Warehouse component on the new Data Warehouse server.
5.
Restore the original OperationsManagerDW database.
6.
Configure Operations Manager to use the OperationsManagerDW database on the new Data Warehouse server.
7.
Restart Operations Manager services.
OperationsManagerDW Database Relocation Procedure
Use the procedure below to move the OperationsManagerDW database to a new Data Warehouse server.
To move the OperationsManagerDW database
1.
Stop Operations Manager services as follows:
a.
On the root management server, stop the System Center Data Access, and the System Center Management Configuration Services.
b.
On the root management server and on all other management servers, stop the System Center Management Service.
2.
On the current Data Warehouse server, use SQL Server Management Studio to back up the OperationsManagerDW database (default name) to a shared folder on the server. It is recommended that you also back up the associated master database.
3.
On the current Data Warehouse server, uninstall the Reporting Data Warehouse component as follows:
a.
Click Start, click Control Panel, and then select
Add or Remove Programs if you are using Windows Server 2003 or select
Programs and Features if you are using Windows Server 2008.
b.
In the Add or Remove Programs for Windows Server 2003 or
Programs and Features for Windows Server 2008, dialog box, select
System Center Operations Manager 2007 R2 Reporting Server, and then select
Change.
c.
In the System Center Operations Manager 2007 Reporting Setup Wizard, on the
Operations Manager 2007 R2 Maintenance page, select
Modify, and then click Next.
d.
On the Custom Setup page, configure the
Data Warehouse component with the This component will not be available option.
e.
Complete the wizard.
Note
This does not physically remove the OperationsManagerDW database from Microsoft SQL Server.
4.
On the current Data Warehouse server, delete the OperationsManagerDW database as follows:
a.
In Microsoft SQL Server Management Studio, navigate to Databases.
b.
Right-click OperationsManagerDW, and then select
Delete.
c.
In the Delete Object dialog box, ensure that the
Delete backup and restore history information for databases and
Close existing connections options are both selected.
5.
On the new Data Warehouse server, run SetupOM.exe to install the Reporting Data Warehouse component as follows:
a.
On the System Center Operations Manager 2007 R2 Setup page, select
Install Operations Manager 2007 R2 Reporting.
b.
In the System Center Operations Manager 2007 R2 Reporting Setup Wizard, on the
Custom Setup page, configure only the Data Warehouse component for installation.
If you are moving the OperationsManagerDW database to a server that is different than the server on which the Operations Manager Reporting component is installed, Configure the
Reporting Server component with the This component will not be available option.
6.
On the new Data Warehouse server, delete the OperationsManagerDW database as follows:
a.
In Microsoft SQL Server Management Studio, navigate to Databases.
b.
Right-click OperationsManagerDW, and then select
Delete.
c.
In the Delete Object dialog box, ensure that the
Delete backup and restore history information for databases and
Close existing connections options are both selected.
7.
On the new Data Warehouse server, use SQL Management Studio to restore the OperationsManagerDW database backup (from step 2). Access the database backup by copying the backup to a local drive or by mapping a local drive to the folder that contains the
backup.
8.
On the new Data Warehouse server, use SQL Management Studio to create a login for the System Center Data Access Service account, the Data Warehouse Action Account, and the Data Reader Account.
Note
If localsystem was used as the System Center Data Access
account, enter <domain\computername$> in SQL Logins.
9.
On the new Data Warehouse server, add the correct login permission for the computer on which the SDK Service is running, as follows:
a.
In Microsoft SQL Server Management Studio, in the Object Explorer
pane, navigate to Security and then expand
Logins.
b.
Right-click the account that corresponds to the computer on which the SDK Service is running (for example, if localsystem is used, it will be <domain\computername$>). 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, select the box that corresponds to the
OperationsManagerDW database.
e.
In the Database role membership for: OperationsManagerDW list, select
OpsMgrReader and db_datareader.
f.
Click OK to save your changes and to close the
Login Properties dialog box.
10.
On the new Data Warehouse server, add the correct login permission for the computer on which the Data Reader Account is running, as follows:
a.
In Microsoft SQL Server Management Studio, in the Object Explorer
pane, navigate to Security and then expand
Logins.
b.
Right-click the Data Reader Account and 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, select the box that corresponds to
OperationsManagerDW.
e.
In the Database role membership for: OperationsManagerDW list, select
OpsMgrReader and db_datareader.
f.
Click OK to save your changes and to close the
Login Properties dialog box.
11.
On the new Data Warehouse server, add the correct permission for the login of the computer on which the Data Warehouse Action Account is running, as follows:
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, and 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, select the box that corresponds to
OperationsManagerDW.
e.
In the Database role membership for: OperationsManagerDW list, select the following items:
OpsMgrWriter and db_owner.
f.
Click OK to save your changes and to close the
Login Properties dialog box.
12.
On the root management server, start the System Center Data Access Service.
13.
On the server running SQL Server Reporting Services, modify the data source as follows:
a.
In Internet Explorer, open http://localhost/reports<$instancename> (include <$instancename> only when using a named instance).
b.
On the SQL Server Reporting Services Home page, ensure that you are viewing the
Contents page. Select Show Details.
c.
In the list that is displayed, click Data Warehouse Main.
d.
In the Data Warehouse Main properties page, in the
Connection string text box, change the name of the database server to the new Data Warehouse server.
e.
Click Apply.
14.
On the server running SQL Server Reporting Services, update the registry to point to the name of the new Data Warehouse server as follows:
a.
Locate the key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft Operations Manager\3.0\Reporting.
b.
Double-click the value DWDBInstance, and then modify it to be the name of the new Data Warehouse server.
If the OperationsManagerDW database was installed on the same server as the Operations Manager Reporting Server, this key does not exist and you need to add it (as a string value).
15.
Configure the Operations Manager database with the name of the new Data Warehouse server as follows:
a.
On the server that hosts the Operations Manager 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 if you are using SQL Server 2005 or select
Edit Top 200 Rows if you are using SQL Server 2008.
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.
16.
Configure the OperationsManagerDW database with the name of the new Data Warehouse server as follows:
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 if you are using SQL Server 2005 or select
Edit Top 200 Rows if you are using SQL Server 2008.
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.
17.
Restart services as follows:
a.
On the root management server, restart the System Center Management Configuration Service.
b.
On all management servers, restart the System Center Management Service.
18.
Verify that the database move was successful as described in the following procedures.
To verify a successful move of the OperationsManagerDW database
1.
Verify that you can successfully run a report from the console.
2.
Ensure that the health state of all management servers in the management group are
Healthy.
If the health state of any management server is
Critical, open Health Explorer, expand
Availability - <server name>, and then continue to expand until you can navigate to
Data Warehouse SQL RS Deployed Management Pack List Request State. Check the associated events to determine if there is an issue accessing the OperationsManagerDW database.
3.
Check operating system events:
a.
Open the operating system's Event viewer. Navigate to Event Viewer, and then to
Operations Manager.
b.
In the Operations Manager pane, search for events with a
Source of Health Service Module and a
Category of Data Warehouse.
The move was successful if event number 31570, 31558, or 31554 exists.
There is an issue accessing the OperationsManagerDW database if event numbers 31563, 31551, 31569, or 31552 exists.
4.
Check events in Operations Manager:
a.
In the Operations console, select Monitoring.
b.
Navigate to Monitoring, Operations Manager,
Health Service Module Events, and then to Performance Data Source Module Events.
c.
Search the Performance Data Source Module Events pane for events with a
Date and Time that is later than the move.
There is a problem with the OperationsManagerDW database if events have a
Source of Health Service Module
and an Event Number of 10103.
Paul Keely
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2010 12:06pm
I hope it will work. the scenario is that the Reporting services installed and was connected to already existed DW which I dunno if it even belong to the same management group... there is a way to configure already exists DW to specific management group
?
Thanks.
October 20th, 2010 10:36pm
Hi,
> there is a way to configure already exists DW to specific management group ?
You can share DW between two or more management groups.
http://blogs.technet.com/b/jonathanalmquist/archive/2009/06/21/multiple-management-groups-single-data-warehouse-part-1.aspx
http://OpsMgr.ru/
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 8:34am
Thanks.
October 25th, 2010 11:26pm