How to recreate the SBSmonitoring database
SBS 2008 comes with a SQL database that has a 4 gig max for that Monitoring database. On some networks with noisy activity or lots of workstations, you’ll ultimately hit that 4 gig database. You’ll know this in two ways – the bpa will alert you and your event errors will indicate you’ve hit the 4 gig max.
So one way to fix this is to merely recreate the database from scratch. So how do you do that if you are not a SQL guru?
You thankfully have the SBS support folks that are. Grab that script from the skydrive, and voila, your database issue is fixed.