The SBSMONITORING Database Files on my server are huge. The mdf file is one gigabyte and the ldf file is over two gigabytes. Yes, the service is running, and yes, it is set to automatic. My C:Drive is just about maxed out. I know - I need to move the database off of the C Partition. But the problem remains - Why is the file so huge, and what can I do about it?
I believe that the problem may have been caused by my antivirus program. I noticed that the background scanner was not set to exclude these files, and I think they may be corrupt. Is there any possible way to just flush these files and start fresh without reinstalling?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Yes, that service is running and set to automatic. I have restarted it several times just to make sure. Actually, after I wrote the question, I was able to get the ldf file down to 46k. But don't ask me how. All I know is that it suddenly dropped from just over 2GB to around 46k practically in a blink of an eye after I closed Server Management Console for the umpteenth time.
But the mdf file is still hovering around one GB. At least I can breathe a little now.
BTW, I have actually tried to move the SBSMONITORING Database off of the C Partition, and I'm stuck. I've followed all of the instructions, and I got as far as detaching the database and copying it to the new location, but unfortunately I can't get it to successfully attach the database in the new location. I keep getting an error saying that the physical file name may be incorrect. I've retyped it several times, and checked and rechecked my spelling and syntax. Clearly something is wrong, but I don't know what.
Business Accounts
Answer for Membership
by: TechSoEasyPosted on 2007-08-13 at 19:33:32ID: 19688985
They shouldn't be that large. YOu say "the service is running", but what service? Because the one that's important here is the SQLAgent$SBSMONITORING service which should be started and set to Automatic. It's THAT service that keeps the file under control.
Now, your AV scanning may very well have been a problem as well... you can certainly just get things in order by reinstalling the Monitoring Features. Just click the "Set up Monitoring Reports and Alerts" link in the Monitoring & Reporting Snap-in, and then select "Reinstall Monitoring Features". This will reset the database file and get you going on the right track.
If you still want to move this off the C partition, then follow the steps outlined in http://sbsurl.com/movedata
Jeff
TechSoEasy