We are using sql server 2000 and recently have had a failover on the cluster and have experienced problems with our jobs. The jobs that are writing out to the logs keep on hanging up for hours and we cannot view the files from within the job. Any ideas?
Which physical drive are the logs being written too? In order for logging to work correctly with SQL Server clustering, the logs must be written to the same physical drive as the SQL Server data files are stored. ----------------------------- Brad M. McGehee, MVP Webmaster SQL-Server-Performance.Com