SQL Server 2000 Backup Job Issue
Posted on 2010-04-05
One of our old production servers running SQL 2000 enterprise edition(SP4) suddenly stopped performing backups on 4/1/2010. When I manually start the jobs they do create backup files but the job never ends. It has to be manually stopped. No errors are evident in the SQL error log or in the job history. Also, when I create a new job by creating a new maintenance plan and then run the job, it does not create any backup files and never completes. Suggestions on troubleshooting and/or resolving the issue will be greatly appreciated. Thank you.