One of our production cluster server having problem with DB maintenance backup job problem. From last 3 days it running continuously (stunk up). I have stopped the job and rerun, but again same problem. I restarted the SQL agent too. But it didn#%92t resolve the problem. I don#%92t know why it is happening. Could anyone please help me?
What is the error message you are getting? check the latest file from, installation path may vary: Crogram FilesMicrosoft SQL ServerMSSQLLOGDB Maintenance Plan01.txt Deepak Kumar --This posting is provided “AS IS†with NO rights for the sake of knowledge sharing.
KBAhttp://support.microsoft.com/?kbid=288577 fyi. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
But the log is stored on the defined path, anyway make sure the hardware has no problems in writing or storing files with appropriate privileges for SQL server service account. As a test try to scheudle a backup job seperately. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
DB maintenance plan is created for 4 databases and It backuping up other databases successfully except one. I am able to take backup of that particular db manually. But It stuck up for that db when its executed by backup job.
Then bin the maintenance plan for this database, recreate a fresh plan in that case. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
What is the size of the database? Any disk space issues on the drive where the backup and data files are stored? Check the maintenance plan log for the error information. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
Database size 17 gb. There is no error log in maint log. I am not getting any error, Job is running continously. I ran the update stat last night.
There must be information for error in SQL Errorlog/ SQL Maintenance Plan log or in Windows events logs: Check the recent errorlog file, at the time when you started plan for backup to when killed the job Crogram FilesMicrosoft SQL ServerMSSQLLOGErrorLog Can you try some alternatives for testing: Change the backup file path to some other drive and test to run the backup job? try taking database backup manually and test if it run successfully or not? check if transaction log backup for this db is getting executed or not? check disk(where backup is going on), if this got some hardware error? Can you see if backup file is being created or not, if file is there when it was last modified? the list may seem you long enough, but its amazing that there is no error logs.. is 17GB total db size including mdf/ndf and ldf files? Deepak Kumar MVP, MCDBA - SQL Server Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.
I ran the update stat last night. That has nothing to do with the backup. As you are getting issues with this particular database, I suggest to create a fresh plan and define a different backup path in order to check the process. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
Change the backup file path to some other drive and test to run the backup job? I changed and tried, but its not working. try taking database backup manually and test if it run successfully or not? Yes, I am able to take backup manually. check if transaction log backup for this db is getting executed or not? The same problem with Transaction log bakup. check disk(where backup is going on), if this got some hardware error? No hardware error. Can you see if backup file is being created or not, if file is there when it was last modified? Once the job executing, no file created by the job, even 0KB file. Surprizing. Total DB size is 22 gb including mdf, ndf and ldf.
When the backup is scheduled using a MP for this database, what do you see from SP_WHO2 results. Just an off-topic, are there any recent changes on this SQL server or for this database? Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
I got some link for the same problem, but didn't find any solution. please refer http://www.developmentnow.com/g/118_2003_10_0_0_464322/Backup-jobs-hang-.htm
http://www.developmentnow.com/g/118_2003_10_0_0_464322/Backup-jobs-hang-.htm<br /><img src='/community/emoticons/emotion-6.gif' alt='' />
Problem got resolved by rebooting the server. I don't know why the most of the problems gets ressolved by reboot the server in Microsoft plateform. <img src='/community/emoticons/emotion-6.gif' alt='' />
It might be during previous application of hotfix or Service pack might not performed. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
