Author: MIchael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
Date: Wed, 3 Oct 2007 08:37:09 -0400
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 [6
Is the backup user also a local admin? -- Matthew Huff | One Manhattanville Rd OTA Management LLC | Purchase, NY 10577 www.otaotr.com | Phone: 914-460-4039 aim: matthewbhuff | Fax: 914-460-4139 My Ne
Author: MIchael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
Date: Wed, 3 Oct 2007 08:50:28 -0400
"Matthew Huff" <mhuff AT ox DOT com> wrote on 10/03/2007 08:45:13 AM: In this case, yes, the AD group "Domain Admins" is explicitly listed as being a member of the local group "Administrators", yes.
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
Author: Craig Duncan <duncan_craigg AT EMC DOT COM>
Date: Wed, 3 Oct 2007 09:30:48 -0400
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 cal
Author: MIchael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
Date: Wed, 3 Oct 2007 09:50:10 -0400
EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU> wrote on 10/03/2007 08:56:43 AM: I'm not the SQL Admin, so I dunno. :-) I did ask the guy who admins this server if there had been any
The uninstall/re-install for the sql-server module doesn't require any reboots. -- Matthew Huff | One Manhattanville Rd OTA Management LLC | Purchase, NY 10577 www.otaotr.com | Phone: 914-460-4039 ai