Verify phase fails on SQL Cluster on Win 2003 Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TechWitch - 18 Jul 2005 20:42 GMT

About 5 months ago, I posted a query to this group after experiencing
failures with my database maintenance plans (during the verify phase)
that run on SQL Clusters on
Windows 2003
(http://groups-beta.google.com/group/microsoft.public.sqlserver.clustering/msg/6a
3dce3dc176c29b?dmode=source)

I was re-posting this in hopes that someone knows of a fix besides
coding a home-brew verify step in to the backup job to check the file's
integrity?

Reply to this Message

Mike Epprecht (SQL MVP) - 19 Jul 2005 13:08 GMT

Hi

Have you turned off anti-virus on the cluster servers?

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> About 5 months ago, I posted a query to this group after experiencing
> failures with my database maintenance plans (during the verify phase)
[quoted text clipped - 5 lines]
> coding a home-brew verify step in to the backup job to check the file's
> integrity?

Reply to this Message

TechWitch - 19 Jul 2005 16:05 GMT

LOL, no. I work for a major anti-virus software company. I seriously
doubt they'd allow me to turn that off. Good suggestion, though.

Reply to this Message

Rodney R. Fournier [MVP] - 19 Jul 2005 16:13 GMT

Ok, then at a minimum exclude the active SQL databases :)

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.itsummitseries.com/experts/fournier.htm - Cluster Summit

> LOL, no. I work for a major anti-virus software company. I seriously
> doubt they'd allow me to turn that off. Good suggestion, though.

Reply to this Message