Try running the query below and look for numbers that might cause
arithmetic overflow in an integer variable.
SELECT used FROM [FS88COPY]..sysindexes where indid in (0, 1, 255)
Compare a manually calculated sum from above with this query.
SELECT sum(used) FROM [FS88COPY]..sysindexes where indid in (0, 1, 255)
How large is the database?
Craig
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of MIchael Leone
Sent: Wednesday, October 03, 2007 5:37 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] SQL backup failing
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
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
|
