Solved

NTBackup Fails to backup System State, CA Arcserve 12 also fails

Posted on 2009-07-13
6
2,109 Views
Last Modified: 2012-05-07
Experts,

I'm running SBS Server 2003 SP2, Sharepoint, Exchange 2003, file server, DHCP, DNS, SQL 2000, SQL 2005, FTP, pretty much everything that it can run. I back it up with CA Arcserve 12 to removable SATA Hard Drives. I upgraded Arcserve to SP2 about a month ago. Ever since then, I have been getting "Incomplete" backups with the following two Arcserve errors:

W3301 2009-07-11 02:46:45 Unable to find directory. (DIR=C:\documents and settings\windows, EC=The system cannot find the file specified.)

W3401 2009-07-11 02:46:45 Unable to find file. (FILE=C:\documents and settings\windows\system32\config\systemprofile\local settings\application data\microsoft\windows\usrclass.dat, EC=The system cannot find the path specified.)

Both errors are because Arcserve is looking for usrclass.dat in a non-existent folder, take a look a the path it is looking for. It should be looking under: C:\windows\system32\config\systemprofile.........    

I pay for Arcserve support and they studied everything, rebuilt the backup jobs, tested JUST backing the system state with Arcserve, and told me that it's my problem, and they "proved" it by attempting to backup the server's system state with NTBackup. NTBackup also fails to backup the system state with this error:

Volume shadow copy creation: Attempt 1.
"MSDEWriter" has reported an error 0x800423f4. This is part of System State. The backup cannot continue.
Error returned while creating the volume shadow copy:800423f4
Aborting Backup.
The operation did not successfully complete.

So, I guess I am trying to figure out why NT Backup fails unless someone knows what is wrong with Arcserve. After NTBackup fails, it throws around 35 errors in the event log. A bunch of Event ID 1 and 6013 errors. There are about nine of these:

Source: VSS
Category: None
Event ID 6013
 
Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error message: BACKUP DATABASE is terminating abnormally.
SQLSTATE: 42000, Native Error: 954
Error state: 1, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: Database 'BBSn_1828_master' has invalid schema.

Most of the  6013's are shorter like this:

Source: VSS
Category: None
Event ID 6013

Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error message: BACKUP DATABASE is terminating abnormally.

There are about 25 of these each somewhat different. If needed I could paste them all in???
Source: SQLVDI
Category: None
Event ID 1
SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=2908. Thread=7432. Server. Instance=SHAREPOINT. VD=Global\{13300DCF-A6F4-479B-98B8-28B875402760}5_SQLVDIMemoryName_0.

Computer Associates said if I can't get NTBackup to work that Arcserve won't work either since they both use the MSDEWriter which seems to be the problem. I can't say whether NTBackup worked before, I have never tried to use it.

All I know is after I installed the Service pack for Arcserve it started doing this and was working before. I feel that CA support has bailed on me but can't get them to understand it was working before I applied the service pack. They said it could be a MS patch ( I keep the server patched up) I have Googled these errors until I have ran out of things to try. Here are some of the things I have tried:

http://forums.techarena.in/windows-server-help/606887.htm

I did not do this one as I am running SP2:
http://blog.tiensivu.com/aaron/archives/256-Im-now-putting-KB-891957-on-all-Windows-2003-servers-that-I-deploy..html

I need some good detective work on this problem, anyone?? I can supply more errors and can try this and that but I can't reboot the server except on Sundays.

0
Comment
Question by:KellyOConnor
[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
  • 4
  • 2
6 Comments
 
LVL 23

Assisted Solution

by:ComputerTechie
ComputerTechie earned 100 total points
ID: 24839926
I would start here:

http://support.microsoft.com/kb/912414

and see if the msdfwriter error goes away.

CT
0
 

Author Comment

by:KellyOConnor
ID: 24840225
Thanks for the reply CT. I've already seen that article and checked the services for the dot backslash problem. Both my SQLSERVERAGENT and MSSQLSERVER services are running under "OMT\Administrator"   (OMT is domain)  accounts. I have googled: NT Backup fails to backup system state, Event ID 6013 and a few other variations and have seen most of what it finds when using those search terms but haven't found any real good things to actually try.
0
 
LVL 23

Expert Comment

by:ComputerTechie
ID: 24840367
Have you tried something simple like reset all the passwords to the same?

CT
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

Author Comment

by:KellyOConnor
ID: 24841193
I just set both services to the same password as the administrator account which is what these two services are using. This should be the same password as the services were already set on ( I inherited this server a year and a half ago so some of these settings are not mine) Do you know what the default login is for these: MSSQLSERVER and SQLSERVERAGENT? Most services are either Local System or Network Service. I wonder if someone set these two services to use the admin account?  
The main thing to consider in all this is that Arcserve was working fine until I put Arcserve SP2 on. Coincidence? Possibly.  The culprit seems to be the MSDEWriter somehow. I don't understand the 35+ errors thrown in the errror log, each a bit different after an attempt with NTBackup to backup the system state to a file.
0
 

Author Comment

by:KellyOConnor
ID: 24854079
Since this server is mission critical and I didn't receive any more help, I broke down and called MS for support. They spent 3.5 hours with me on the phone tried many different things and even a hotfix.  The final fix was to disable Sharepoint 2.0 since we are running Sharepoint 3.0  After disabling Sharepoint 2.0 Service:  MSSQL$SHAREPOINT NTBackup was able backup the system state without error.
0
 

Accepted Solution

by:
KellyOConnor earned 0 total points
ID: 24895319
Since this was not an actual fix, I told Microsoft it was unacceptable to disable this service and not determine the root cause of the problem. They spent an additional 10 hours working on this using at least three different techs finally enlisting an SQL Server expert who determined that one of the SQL databases had an invalid schema. Also, this particular database was not needed so we simply deleted it and NTBAckup was able to run successfully without disabling the MSSQL$SHAREPOINT service. So, I will close this question.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
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…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

734 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