moving MOM reporting DB

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

moving MOM reporting DB

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> MOM >> moving MOM reporting DB

Page: [1]

Message

<< Older Topic Newer Topic >>

moving MOM reporting DB - 2/17/2006 3:00:25 AM

nmalik

Posts: 55
Score: 0
Joined: 2/2/2005
Status: offline

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

Post #: 1

RE: moving MOM reporting DB - 2/17/2006 10:07:40 AM 1 votes

pzerger

Posts: 47
Score: 2
Joined: 12/10/2005
Status: offline

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

_____________________________

Regards,

Pete Zerger MCSE (Messaging), MVP-MOM
http://www.systemcenterforum.org
OpsMgr Training
http://www.systemcenterforum.org/training

(in reply to nmalik)

Post #: 2

RE: moving MOM reporting DB - 2/17/2006 12:27:06 PM

nmalik

Posts: 55
Score: 0
Joined: 2/2/2005
Status: offline

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?

(in reply to nmalik)

Post #: 3

RE: moving MOM reporting DB - 2/20/2006 5:52:13 AM

adominey

Posts: 671
Score: 33
Joined: 12/15/2004
From: Southampton, UK
Status: offline

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

Andy

_____________________________

Please feel free to rate this post :-)

Andy Dominey | Consultant | 1E Ltd

http://www.1e.com

Microsoft MVP - MOM

Visit my blog here: http://myitforum.com/cs2/blogs/adominey/default.aspx

(in reply to nmalik)

Post #: 4

RE: moving MOM reporting DB - 2/21/2006 2:40:17 AM

nmalik

Posts: 55
Score: 0
Joined: 2/2/2005
Status: offline

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?

(in reply to nmalik)

Post #: 5

RE: moving MOM reporting DB - 3/5/2006 11:40:14 PM

nmalik

Posts: 55
Score: 0
Joined: 2/2/2005
Status: offline

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.

(in reply to nmalik)

Post #: 6

RE: moving MOM reporting DB - 8/24/2006 8:41:09 AM

skuvshinkova

Posts: 1173
Score: 125
Joined: 8/29/2002
From: Russia
Status: offline