SQL Server Performance

Clustering and jobs hanging

Discussion in 'SQL Server Clustering' started by Simu, Apr 11, 2006.

  1. Simu New Member

    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?
  2. bradmcgehee New Member

    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

Share This Page