How is access setup in the database? AD or SQL Server based? We run the
sql back as the same user the sql server and sql agent are set in as the
"logon as" in the service.
You might try to uninstall and install the legato sql client. It reset
some of the perms. Also, anything interesting in the local nsr\applogs
files on the sql server?
----
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: Michael.Leone AT pha.phila DOT gov [mailto:Michael.Leone AT pha.phila DOT
gov]
Sent: Wednesday, October 03, 2007 8:50 AM
To: Matthew Huff
Cc: EMC NetWorker discussion
Subject: RE: [Networker] SQL backup failing
"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
|
