sqlserver writer fails for MMSSEE database

Cruthin
Cruthin used Ask the Experts™
on
Dear Experts,

I have an SBS2008 server and recently installed windows SP2 and exchange SP3 plus any other outstanding updates.  The next scheduled backup and every one since have failed. The failure was caused by the vss sqlserverwriter. Vssadmin reports:

Writer name: 'SqlServerWriter'
   Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
   Writer Instance Id: {cc18327c-615f-429b-ad99-16cdc1caa8ea}
   State: [8] Failed
   Last error: Non-retryable error

I have narrowed it down further to an SQL instance. The Service is called "windows internal database (MICROSOFT##SSEE)"   When i stop this service and perform a backup (even with the  "VSS SQL server writer" service started, )  the backup completes perfectly.
To my knowledge, this database is used by wsus, sharepoint and other services.

I can write a script to stop this service before the backup then start it again, but I would like to put it right properly.

How can I resolve this one?  

I have posted this before on EE but it seems to have run out of interest - so sorry for double-posting!

Thanks in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Bhavesh ShahLead Analyst
Top Expert 2010

Commented:

Author

Commented:
Certainly looks like there might be a solution in there somewhere! I will go through them and respond accordingly.

Thanks.

Author

Commented:
I believe that the issue may lie with Sharepoint services. I need to restore a backup of the server to a non-production box to attempt a repair.   I will be following the procedures here http://technet.microsoft.com/en-us/library/dd540850(WS.10).aspx 

Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

Commented:
I restored the server to another box and applied this suggestion: http://blogs.technet.com/b/sbs/archive/2010/06/18/companyweb-and-sharepoint-central-admin-not-accessible-after-installing-kb983444.aspx

First backup ran 100%  Good start. Still some more testing of sharepoint required though.

Looks like "an update which patches one thing, but breaks another"  has been released again.
Bhavesh ShahLead Analyst
Top Expert 2010

Commented:

=) Good.

All The Best
Awarded 2009
Top Expert 2010

Commented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial