SMS_HEALTH database

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:

SMS_HEALTH database

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

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> SMS_HEALTH database

Page: [1]

Message

<< Older Topic Newer Topic >>

SMS_HEALTH database - 9/24/2008 3:37:13 PM

phenry194

Posts: 197
Score: 0
Joined: 3/30/2007
Status: offline

Please forgive my stupid question, but what is the purpose of the sms_health database in sql on the sms server? I'm assuming it is to log the status of the sms database in one way or another, but can someone please provide me with some more information? Our DBA that backs up our databases asked me the purpose of the particular database the other day and I realized I couldn't really give him a complete explanation. Thanks. : )

Post #: 1

RE: SMS_HEALTH database - 9/24/2008 4:37:30 PM

gjones

Posts: 844
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

FYI only remember that you have to use the SMS Backup task if you want to restore your SMS site. If you use SQL backup to restore your site you will end up with problems.

Therefore I make sure that SMS is backing working and change it to daily instead of weekly. And tell all SQL admin not to backup the database as SMS will do it.

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to phenry194)

Post #: 2

RE: SMS_HEALTH database - 9/24/2008 6:13:43 PM

pwstrain

Posts: 122
Score: 9
Joined: 3/11/2007
From: Danville, Illinois
Status: offline

The SMS_ClientHealth DB is created when you install the Client Health Monitoring tool. Perhaps it was renamed if installed on your system.
That said I agree with GJones above - make sure that the SMS Backup task is doing it's job. If the SQL guy is backing it up, it may prevent the task from completing successfully.

_____________________________

My Personal Blog
My Technical Blog

(in reply to gjones)

Post #: 3