EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU> wrote on
10/03/2007 08:56:43 AM:
> How is access setup in the database? AD or SQL Server based?
I'm not the SQL Admin, so I dunno. :-) I did ask the guy who admins this
server if there had been any changes to the security or user settings, and
he said no. I'll ask again.
> 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.
No, the backup account is a separate account from the service account,
which is - I think - the recommended method (if you use the same account,
and it has a problem - inadvertently change a password, etc - it doesn't
take down all everything).
> 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?
Nothing that I can see ....
I'd have to schedule some time for the uninstall / reinstall (knowing
Windows, I'd want to reboot between the uninstall and install, just to be
sure).
>
>
>
>
> ----
> 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
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
|