[Networker] SQL backup failing
2007-10-03 08:46:00
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
|
|
|