Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!
Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!
Act now. This offer ends July 14, 2017.
Course Of The Month
3 days, 9 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
Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A lot of problems and solutions are available on the net for the error message "Source server does not meet minimum requirements for migration" while performing a migration from Small Business Server 2003 to SBS 2008. This error pops up just before …
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade. That can be fixed so it 'works around' agai…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Course of the Month3 days, 9 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.