moving MOM reporting DB (Full Version)

All Forums >> [Management Products] >> MOM



Message

nmalik -> moving MOM reporting DB (2/17/2006 3:00:25 AM)

The systemcenterreporting db is on the MOM server and i' d like to move it with all the reports intact. Anybody done this before?



pzerger -> RE: moving MOM reporting DB (2/17/2006 10:07:40 AM)


1) If you have any custom reports, export them.
2) Uninstall MOM Reporting. This will not delete the SystemCenterReporting
DB.
3) Detach the SystemCenterReporting DB using SQL Enterprise manager.
4) Install MOM Reporting on the new machine
5) Detach the SystemCenterReporting DB on the new machine, replace the DB file with the old file you detached in step 3. That way you keep your old
data.
6) Import the reports for your existing MP' s using the MP Import wizard in
the MOM Admin Console.
7) Import your custom reports
8) Setup the SQL Reporting Services permissions to allow users to browse the new reports



nmalik -> RE: moving MOM reporting DB (2/17/2006 12:27:06 PM)

Thanks Pete - I' d like to retain MOM reporting services on the old server until such time that the new sever is totally functioning. Is that possible? Can I have two active MOM reporting servers? On the same note, is there a regkey that tell the management server where the reporting server is? in a dual reporting server confifuration if I re-import the MP reports how will it know where to deploy the report definition files?



adominey -> RE: moving MOM reporting DB (2/20/2006 5:52:13 AM)

You could also backup and restore the ReportServer DB to recover the reports.

Andy



nmalik -> RE: moving MOM reporting DB (2/21/2006 2:40:17 AM)

ok... Im getting a desparate here. I removed the MOM reporting services componenent from my old MOM 2005 server. MOM reporting services is now installed on a dedicated sql server server. When I click on the reporting console link in the MOM administrator console it still takes me to the old server. I reimported the MP reports and none of them show up if I navigate to the new server. Any ideas?




nmalik -> RE: moving MOM reporting DB (3/5/2006 11:40:14 PM)

I finally fixed this. Two entries in the ReportingSettings. I remved the row with the old server and now the console points to the new reporting server. It would be nice if MS posts the mom db schema.



skuvshinkova -> RE: moving MOM reporting DB (8/24/2006 8:41:09 AM)

quote:

It would be nice if MS posts the mom db schema


See article about this: http://www.microsoft.com/technet/prodtechnol/mom/mom2005/Library/e7d95955-058b-43f4-ae12-7506aff9f5f7.mspx?mfr=true



janebush08 -> RE: moving MOM reporting DB (8/22/2008 12:25:46 AM)

Great article Svetlana... thanks for sharing the link...



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.15625