Networker

[Networker] SQL backup failing

2007-10-03 08:46:00
Subject: [Networker] SQL backup failing
From: MIchael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 3 Oct 2007 08:37:09 -0400
My NetWorker jobs to backup one of my SQL servers has started to fail. 
Here's what nrsqlsv.log says (domain, user and server names sanitized):

09/12/07 18:00:06 Start time Wed Sep 12 18:00:06 2007
[6248] [I]  09/12/07 18:00:06 Computer Name: SQL-SERVER     User Name: 
domain.local\backup-user(backup-user)
[6248] [I]  09/12/07 18:00:06 System Version: 5.2 Build 3790 Service Pack 
2
[6248] [I]  09/12/07 18:00:06 Microsoft Data Access Component(MDAC) 
version: 2.82.3959.0
[6248] [I]  09/12/07 18:00:06 Microsoft SQL Server version (from registry) 
: 9.00.3042.00
[6248] [I]  09/12/07 18:00:06 Local host has following SQL Server online: 
[6248] [I]  09/12/07 18:00:06           MSSQL server : SQL-SERVER
[6248] [I]  09/12/07 18:00:06 Use Legato Networker Server : 
BACKUP-SERVER.domain.local
[6248] [I]  09/12/07 18:00:06 Legato Networker Server Version: NetWorker 
nw_7_3_2_jumbo.Build.11 Network Edition/70
[6248] [I]  09/12/07 18:00:06 nsrexecd.exe Version: 
nw_7_3_2_jumbo.Build.11 
[6248] [I]  09/12/07 18:00:06 nsrsqlsv.exe Version: 5.0.0.154 Supporting 
SQL 7.0, SQL 2000, and SQL 2005
[6248] [I]  09/12/07 18:00:07 Command line:
[6248] [I]  09/12/07 18:00:07   C:\Program 
Files\Legato\nsr\bin\nsrsqlsv.exe -s BACKUP-SERVER.domain.local -g 
SQL-SERVER SQL -LL -m SQL-SERVER -l full -q -W 78 -N MSSQL: MSSQL: 
[6248] [I]  09/12/07 18:00:08 SQL Connection to SQL-SERVER is created. SQL 
Server Version is 09.00.3042
            NSR_BACKUP_LEVEL: full;
                   NSR_GROUP: SQL-SERVER SQL;
            NSR_SAVESET_NAME: "MSSQL:";
                  NSR_SERVER: BACKUP-SERVER.domain.local;
[6248] [E]  09/12/07 18:00:16 Microsoft SQL Server Provider error:
[6248] [E]  09/12/07 18:00:16 Arithmetic overflow error converting 
expression to data type int..
[6248] [E]  09/12/07 18:00:16 (nsrsqlado.cpp)372:SELECT sum(used) FROM 
[FS88COPY]..sysindexes where indid in (0, 1, 255) returns null RecordSet.
[6248] [E]  09/12/07 18:00:16 Execute DB command <SELECT sum(used) FROM 
[FS88COPY]..sysindexes where indid in (0, 1, 255)> failed
[6248] [E]  09/12/07 18:00:16 Microsoft SQL Server Provider error:
[6248] [E]  09/12/07 18:00:16 Cannot open backup device 
'Legato#3b118132-7c42-434e-831c-98b37627637d'. Operating system error 
0x80070005(Access is denied.)..
[6248] [E]  09/12/07 18:00:16 BACKUP DATABASE is terminating abnormally..
[6248] [E]  09/12/07 18:00:16 
Backup/Recover command failed
[6248] [E]  09/12/07 18:00:16 Processing FS88COPY failed, the item will be 
skipped.

The user (backup-user) is a member of the AD groups "Backup Operator" and 
also "Domain Admins", so the account should have access to whatever it 
needs. I've seen the "Arithmetic overflow error converting expression to 
data type int" before, but it's never caused the entire backup to fail 
before; it just skipped that particular database, and went on to copy the 
other databases. So I think the problem is something else. I have verified 
that all our licenses are correct, and haven't expired.

How to proceed troube-shooting this? I haven't rebooted this server is 
approx 30 days now, altho I don't think that classic "Windows fix" will 
solve this.

Thanks

-- 
Michael Leone
Network Administrator, ISM
Philadelphia Housing Authority
2500 Jackson St
Philadelphia, PA 19145
Tel: 215-684-4180
<mailto:michael.leone AT pha.phila DOT gov>

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

<Prev in Thread] Current Thread [Next in Thread>