Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
COURSE of the MONTH
12 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
purge or delete or re-initilaise sbsmonitoring database (sbsmonitoring.mdf, sbsmonitoring.ldf)
Posted on 2012-12-22
Hi,
I currently have the SBSMonitoring database using a huge amount of space on Small Business Server 2008 (sbs2008)
sbsmonitoring.mdf 994.2MB
sbsmonitoring.mdf 611.1MB
Is there an easy way to purge, delete or re-initialise this database to get the size down ?
Regards
Michael
I currently have the SBSMonitoring database using a huge amount of space on Small Business Server 2008 (sbs2008)
sbsmonitoring.mdf 994.2MB
sbsmonitoring.mdf 611.1MB
Is there an easy way to purge, delete or re-initialise this database to get the size down ?
Regards
Michael
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
3
8 Comments
Active today
Hi:
In the SBS console, under Monitoring, run the setup wizard. This will clear the history so you will not have comparisons in the reports, but it will lower the space consumed.
How big is your system partion? 1.5 GB is not "huge" for this database.
In the SBS console, under Monitoring, run the setup wizard. This will clear the history so you will not have comparisons in the reports, but it will lower the space consumed.
How big is your system partion? 1.5 GB is not "huge" for this database.
Active today
Sorry, keep getting the versions mixed....
You still are nowhere near any limits on these files. If your system partition is lacking free space, either the partition is too small or there are other things using the space.
Here are two articles that explain it. Note, Please read them both to the end.
http://blogs.technet.com/b/sbs/archive/2009/07/14/sbs-2008-console-may-take-too-long-to-display-alerts-and-security-statuses-display-not-available-or-crash.aspx
and
http://www.thirdtier.net/2010/03/sbs-2008-monitoring-database-fills-to-capacity/
You still are nowhere near any limits on these files. If your system partition is lacking free space, either the partition is too small or there are other things using the space.
Here are two articles that explain it. Note, Please read them both to the end.
http://blogs.technet.com/b/sbs/archive/2009/07/14/sbs-2008-console-may-take-too-long-to-display-alerts-and-security-statuses-display-not-available-or-crash.aspx
and
http://www.thirdtier.net/2010/03/sbs-2008-monitoring-database-fills-to-capacity/
The customer's C: drive is quite small - hence the issue.
I read all three articles - have seen this about updateSBSMonitoring.sql before.
I ran updateSBSMonitoring.sql per the procedure.
It did NOT decrease the database size - it INCREASED IT !. And the log file size TOO ! (to over a gig).
Is this the result you expected ?
I read all three articles - have seen this about updateSBSMonitoring.sql before.
I ran updateSBSMonitoring.sql per the procedure.
It did NOT decrease the database size - it INCREASED IT !. And the log file size TOO ! (to over a gig).
Is this the result you expected ?
Active today
Not what I expected and not sure what that is about, but you will be fighting this forever. Probably better to increase the size of the system partition.
Also, "run as administrator" either wirdirstat or treesizepro to see what else is consuming space on that system.
Also, "run as administrator" either wirdirstat or treesizepro to see what else is consuming space on that system.
OK - it looks like it needed a shrink as well. Database is now 120Mb.
Here is the batch file I developed that worked :
Rem script developed from :
Rem http://blogs.technet.com/b/sbs/archive/2009/07/14/sbs-2008-console-may-take-too-long-to-display-alerts-and-security-statuses-display-not-available-or-crash.aspx
Rem Find and stop the SQL Server (SBSMONITORING) service.
NET STOP MSSQL$SBSMONITORING
MKDIR C:\TEMP
MKDIR C:\Temp\DataBackup
Rem backup all databases and log files in this directory
XCOPY /E /C /H /R /Y "C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
Rem Restart service
NET START MSSQL$SBSMONITORING
Rem Run downloaded SQL to EXECUTE [SBSMonitoring].[dbo].[Cle
Sqlcmd -S %computername%\SBSMonitori
sqlcmd -S %computername%\SBSMonitori
PAUSE
Here is the batch file I developed that worked :
Rem script developed from :
Rem http://blogs.technet.com/b/sbs/archive/2009/07/14/sbs-2008-console-may-take-too-long-to-display-alerts-and-security-statuses-display-not-available-or-crash.aspx
Rem Find and stop the SQL Server (SBSMONITORING) service.
NET STOP MSSQL$SBSMONITORING
MKDIR C:\TEMP
MKDIR C:\Temp\DataBackup
Rem backup all databases and log files in this directory
XCOPY /E /C /H /R /Y "C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
Rem Restart service
NET START MSSQL$SBSMONITORING
Rem Run downloaded SQL to EXECUTE [SBSMonitoring].[dbo].[Cle
Sqlcmd -S %computername%\SBSMonitori
sqlcmd -S %computername%\SBSMonitori
PAUSE
Featured Post
Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This guide is intended for migrating Windows 2003 Standard with Exchange 2003 to Windows Small Business Server 2008.
You will need the following:
Exchange Best Practice Analyzer: http://www.microsoft.com/downloads/details.aspx?FamilyID=DBAB201F-…
The problem of the system drive in SBS 2003 getting full continues to be an issue, even though SBS 2008 and SBS 2011 are both in the market place. There are several solutions to this, including adding additional drive space or using third party uti…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month12 days, 11 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.