Win2003 Cluster and 'verify' cmd from SQL

#1

Verifies of my backup jobs are repeatedly failing from "Cannot Open Device"
errors on my new Win2003 cluster when run from the maintenance plan job.
When I try the path, it is valid and I can run the verify statement manually
for the file and it completes successfully. Has anyone encountered this
problem before?

TW

#2

"Tech Witch" <tech.witch (AT) gmail (DOT) NOSPAM.com> wrote

Quote:

Verifies of my backup jobs are repeatedly failing from "Cannot Open
Device"
errors on my new Win2003 cluster when run from the maintenance plan job.
When I try the path, it is valid and I can run the verify statement
manually
for the file and it completes successfully. Has anyone encountered this
problem before?

Make sure SQL Server Agent is running as a domain account that has access to
the device.

Quote:

TW

#3

I have the same issue and couldn't find why. I disabled the verify option in
the maintenance plan and the backup is ok.

Both SQL and Agent services running under domain account with Admin rights
to Windows and SQL.

Ayad

"Greg D. Moore (Strider)" <mooregr_deleteth1s (AT) greenms (DOT) com> wrote

Quote:

"Tech Witch" <tech.witch (AT) gmail (DOT) NOSPAM.com> wrote in message
news:GN5Od.39387$iC4.39382 (AT) newssvr30 (DOT) news.prodigy.com...
Verifies of my backup jobs are repeatedly failing from "Cannot Open
Device"
errors on my new Win2003 cluster when run from the maintenance plan job.
When I try the path, it is valid and I can run the verify statement
manually
for the file and it completes successfully. Has anyone encountered this
problem before?

Make sure SQL Server Agent is running as a domain account that has access
to
the device.

TW

#4

<a> wrote

Quote:

I have the same issue and couldn't find why. I disabled the verify option
in
the maintenance plan and the backup is ok.

Both SQL and Agent services running under domain account with Admin rights
to Windows and SQL.

Ayad

Make sure SQL Server Agent is running as a domain account that has
access
to
the device.

Same here, the Agent is fine and running under a domain account, or else the
backup job wouldn't run at all. I have a sample verify proc you can insert
in a step after the Maint. plan runs if you're interested.

TW

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Win2003 Cluster and 'verify' cmd from SQL

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Win2003 Cluster and 'verify' cmd from SQL - 02-08-2005 , 10:29 AM

Re: Win2003 Cluster and 'verify' cmd from SQL - 02-08-2005 , 09:12 PM

Re: Win2003 Cluster and 'verify' cmd from SQL - 02-09-2005 , 08:53 AM

Re: Win2003 Cluster and 'verify' cmd from SQL - 02-09-2005 , 12:54 PM