Yes – I had this happen on my SBS 2008 server myself. Instead of taking the normal route to try and resolve it however, I decided to mess with a few SQL commands and try to dig under the covers to see if I could delete data that was too old. I thought that this might allow me to reduce the content of the database so that I could not go through the hassle of replacing it. Sadly my SQL skills are not that good and I ended up making the database log files all that much more bigger to the point that I nearly ran out of disk space.
Oh well – I tried it on my system and not a customers system.
End result however is that if your SBS 2008 Monitoring Database grows beyond the 4GB limit, you’ve got no real choice but to replace it with an empty one. Best place to get one is from a new customer server – or if you don’t have one of those, then you can download a fresh one from here .
Once you have your empty database, the procedure is quite simple.
- Stop any backups that you have running – ie the SBS 2008 backup or ShadowProtect.
- Open the Services MMC from the Administrative Tools program group
- Stop the Windows SBS Manager service and the SQL Server (SBSMONITORING) service.
- Rename or in my case delete the SBSMonitoring.mdf and the SBSMonitoring_log.ldf files from the C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder
- Copy the replacement LDF and MDF files into the same location
- Start the SQL Server (SBSMONITORING) service
- Start the Windows SBS Manager service
- Given that you’ve replaced the database with an empty one, you will need to use the SBS 2008 Console and reconfigure your reporting and alerts.
- Also do not forget to re-enable your backups once more and do a backup of your server with the new database in place.
To configure SBS 2008 Alert Notifications do the following;
- Open the Windows SBS Console
- Select the Network tab
- Select the View notification settings task from the task pane on the right hand side
- Select the Email Address tab and enter in your email address for notifications
- Select OK to close and save the settings
To configure SBS 2008 Reports do the following;
- Open the Windows SBS Console
- Select the Reports tab
- Select the Add a new report task from the task pane on the right hand side
- Configure the report to contain the information you need and select OK
I all the time used to study post in news papers but now as I am a user of internet therefore from now I am
using net for articles, thanks to web.
You actually make it appear really easy together with your presentation but I in finding this
matter to be really one thing which I think I would
by no means understand. It seems too complex and extremely
large for me. I am taking a look forward
to your next put up, I will attempt to get the grasp of it!
Excellent post. I used to be checking constantly this blog and I’m inspired!
Very useful information specially the final section :
) I deal with such information much. I was looking for this certain info for a long time.
Thank you and good luck.
You are so awesome! I don’t suppose I have read through anything like this
before. So great to find someone with a few unique thoughts on this issue.
Really.. many thanks for starting this up. This web site is something that’s needed
on the web, someone with some originality!
Can you tell us more about this? I’d love to find out
more details.
Wonderful post however , I was wanting to know if you could
write a litte more on this subject? I’d be very thankful if you could elaborate a little bit more.
Bless you!
Un сonsidérable remerϲiement au ϲréateur de ce site web
Herе is myy homepage … clip adulte gratuit
Superb post but I was wondering if you could write a litte more on this subject?
I’d be very grateful if you could elaborate a little bit more.
Kudos!
One thing that goes in complete favor of corporate apartments is that there are no hidden charges.
Quay Apartment is an excellent leader to providing holiday
service apartments Manchester and cheap hotels manchester city
centre in United Kingdom. With so many more attractions to be explored,
Edinburgh has the magic of making your holiday or business trip very interesting and exciting.
You can cook for yourself in your serviced apartment and enjoy the food of
your choice.
It all depends upon what you wear and what you take along with you.
Your vehicle can be backed right up to the water and can be left while you
explore the area waterways. Some people devote their lives to activities such as kayaking.
And who would miss the funny acrobatic dolphin show in the blue horizons and fascinating acrobatic presentations Odyssea show with an underwater theme.
Wow that was unusual. I just wrote an incredibly long comment but after I clicked submit my comment
didn’t appear. Grrrr… well I’m not writing all that over
again. Anyhow, just wanted to say great blog!
Keep up the amazing job !! Lovin’ it! If you loved this short article and you would such as to get even more details relating to horizon treadmill reviews price range kindly browse through our webpage.| http://findyourtreadmill.com
The link for the db is now broken