"Matthew Huff" <mhuff AT ox DOT com> wrote on 10/03/2007 08:45:13 AM:
> Is the backup user also a local admin?
In this case, yes, the AD group "Domain Admins" is explicitly listed as
being a member of the local group "Administrators", yes. No access rights
for the domain account have changed, AFAICT. The job just stopped working.
:-) I thought originally it was because some of my licenses had
inadvertently expired, but I have already resolved that problem (see a
prior posting from 2007-09-27 about that). So I am unclear as to why it
can't access the backup resources it needs (I think that's what this error
is telling me).
>
>
> ----
> Matthew Huff | One Manhattanville Rd
> OTA Management LLC | Purchase, NY 10577
> www.otaotr.com | Phone: 914-460-4039
> aim: matthewbhuff | Fax: 914-460-4139
>
>
>
>
> -----Original Message-----
> From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU]
> On
> Behalf Of MIchael Leone
> Sent: Wednesday, October 03, 2007 8: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
|