While investigating a cluster resource offline issue, came across following three errors in windows system event log, cluster log and SQL error log respectively, Error message 1 Source: ClusSvc Category: Failover Mgr Type: Error Event ID: 1069 User: N/A Computer: < Computer Name > Description: Cluster resource ‘SQL Server ()’ in Resource Group ‘‘ failed. Error message 2 Error in the Cluster log file, SQL Server < SQLServer >: [sqsrvres] Unable to read the ‘VirtualServerName’ […]

Today, while doing some maintenance plan modification encountered a unique issue, recieved following error while modifying/opening any maintenance plan or job, Error Screenshots: Job error: Maintenance Plan error: Later on investigation found that this is a known bug with SQL Server 2005 SP2 that if SQL Server name exceeds 30 chars then this issue will occur, for e.g. if SQL server name is dazsqlmper234_1234\dbajsasalsa_456 Issue: SQL Agent Jobs and Maint plans are not editable when […]

I was struggling to identify the DTS package name from the job syntax which looks like, DTSRun /~Z0x5B431B25562BD74…2AE391DF759D0B3B09EEAB94B687E05E66CE7307C6304204 this can be simulated by right clicking the DTS Package (SQL 2000) and schedule a job. If you schedule a package to run that way, the SQL Job it creates will have an encrypted name for DTS package in SQL job step – similar to what you see above. Found a solution to this at following link […]