Solved

SharePoint 2007 SP2 VSS backup error ?

Posted on 2010-09-08
6
1,308 Views
Last Modified: 2013-12-01
Hi Everyone,

I've been getting this error below all the time regarding the VSS backup error in the event viewer, eventhough the VSS Writer status got no error in the cmd prompt.

and also Symantec Backup Exec 2010 R2 agent got error in backup the farm using the DOMAIN\SPService username which is the owner of this WSS_ContentDB and also member of the Farm admin group.

can anyone share your experience here to fix this error please ?

Thanks,
JJ
Log Name:      Application

Source:        Windows SharePoint Services 3

Date:          8/09/2010 10:11:31 PM

Event ID:      3760

Task Category: Database

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      MOSSDEV01.domain.com

Description:

SQL Database 'SharePoint_AdminContent_f632e5bf-cbd9-4d9f-a819-1811feb4f2b6' on SQL Server instance 'MOSSDEV01\MOSSDB' not found. Additional error information from SQL Server is included below.



Cannot open database "SharePoint_AdminContent_f632e5bf-cbd9-4d9f-a819-1811feb4f2b6" requested by the login. The login failed.

Login failed for user 'DOMAIN\Administrator'.

#########################################################################################################################################################

Log Name:      Application

Source:        VSS

Date:          8/09/2010 10:08:52 PM

Event ID:      12289

Task Category: None

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      MOSSDEV01.domain.com

Description:

Volume Shadow Copy Service error: Unexpected error RegOpenKeyExW(-2147483646,SYSTEM\CurrentControlSet\Services\VSS\Diag,...).  hr = 0x80070005. 



Operation:

   Initializing Writer



Context:

   Writer Class Id: {8d5f38cd-fb7a-49ca-ae1b-21d1f017d8f9}

   Writer Name: OSearch VSS Writer

   Writer Instance ID: {b87cc4be-935b-4479-ac5d-618a41767a0f}

#

#----------------------------------------------------------------------------------------------------------------------------------------------------# 

#Command Prompt

#----------------------------------------------------------------------------------------------------------------------------------------------------#

# 

C:\Windows\system32>vssadmin list writers

vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool

(C) Copyright 2001-2005 Microsoft Corp.



Writer name: 'System Writer'

   Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}

   Writer Instance Id: {34de22c6-4a77-4af6-9ae6-1b4eee4d629b}

   State: [1] Stable

   Last error: No error



Writer name: 'SqlServerWriter'

   Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}

   Writer Instance Id: {c6074e09-4962-4290-9639-d8cc7d08f644}

   State: [1] Stable

   Last error: No error



Writer name: 'WMI Writer'

   Writer Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0}

   Writer Instance Id: {76d8b78a-0c87-464f-b538-4fee7c515f42}

   State: [1] Stable

   Last error: No error



Writer name: 'ASR Writer'

   Writer Id: {be000cbe-11fe-4426-9c58-531aa6355fc4}

   Writer Instance Id: {45b2f7f5-91e6-4607-a6df-ef85bebe8770}

   State: [1] Stable

   Last error: No error



Writer name: 'COM+ REGDB Writer'

   Writer Id: {542da469-d3e1-473c-9f4f-7847f01fc64f}

   Writer Instance Id: {48f71749-817b-4f11-b97a-1f63f525626e}

   State: [1] Stable

   Last error: No error



Writer name: 'SPSearch VSS Writer'

   Writer Id: {57af97e4-4a76-4ace-a756-d11e8f0294c7}

   Writer Instance Id: {9f4ab399-ff20-4dae-9063-7b737d52edd3}

   State: [1] Stable

   Last error: No error



Writer name: 'Shadow Copy Optimization Writer'

   Writer Id: {4dc3bdd4-ab48-4d07-adb0-3bee2926fd7f}

   Writer Instance Id: {e9efb4dd-8e77-42c1-90ef-55b879ee60b2}

   State: [1] Stable

   Last error: No error



Writer name: 'Registry Writer'

   Writer Id: {afbab4a2-367d-4d15-a586-71dbb18f8485}

   Writer Instance Id: {db5e3151-2f42-4aa7-acb7-b1ffe169cd2a}

   State: [1] Stable

   Last error: No error



Writer name: 'OSearch VSS Writer'

   Writer Id: {8d5f38cd-fb7a-49ca-ae1b-21d1f017d8f9}

   Writer Instance Id: {b87cc4be-935b-4479-ac5d-618a41767a0f}

   State: [1] Stable

   Last error: No error



Writer name: 'IIS Config Writer'

   Writer Id: {2a40fd15-dfca-4aa8-a654-1f8c654603f6}

   Writer Instance Id: {9f5a29f8-93f8-48a6-8330-605423ad951b}

   State: [1] Stable

   Last error: No error



Writer name: 'IIS Metabase Writer'

   Writer Id: {59b1f0cf-90ef-465f-9609-6ca8b2938366}

   Writer Instance Id: {c9bc929c-4357-4028-81d6-8b48e6b65c13}

   State: [1] Stable

   Last error: No error



C:\Windows\system32>

Open in new window

error.jpg
0
Comment
Question by:jjoz
  • 4
  • 2
6 Comments
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 500 total points
ID: 33626784
Sidenote......Symantec products absolutely suck at backing up SharePoint.

Are you doing a SharePoint specific backup?  Or are you just trying to backup the SQL databases?  Is SPService an admin on your WFE server?
0
 
LVL 1

Author Comment

by:jjoz
ID: 33626997
yes i must admit man :-|
at the moment SPService not a local admin ...
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 33627143
try it temporarily.  i just don't know how this product is backing sharepoint up.  have you double checked all things in their setup guide?

what permissions does domain\admin have on the SQL box?  if you look at the properties of the acount, under mappings, what permissions does it have on the _admin database?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 1

Author Comment

by:jjoz
ID: 33679341
thanks man, you're right the problem was solved after making sure that the logon Admin right in the backup Exec is the same as the Farm Admin account and SQL Server DB Owner.
0
 
LVL 1

Author Closing Comment

by:jjoz
ID: 33679342
thanks man for the inspiration !
0
 
LVL 1

Author Comment

by:jjoz
ID: 33679359
or like this in the most simplest form: Farm Admin = WSS_Content_DB Owner = BE Default Logon Account
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now