October 16, 2015 at 6:44 am
Hi,
I have strange situation happening in sql 2005 environment where I have around 37 gb database. I have a night backup maintenance job that takes around 2 to 2.5 hrs to take full backup of this db.
When I right click that db, take backup then it completes in 30 minutes.
I tried to run both jobs during same time and there were no other jobs or activity on server that time still manual backup is faster than scheduled job. Why is that happening? Any suggestions?
October 16, 2015 at 6:50 am
Are you backing up to the same location for both the tests?
October 16, 2015 at 6:52 am
Yeah its same location with lot of space available. Everything is same.
October 16, 2015 at 6:58 am
Can you post screenshots of the maintenance plan with the settings, and also the query for your manual backup via the script button at the top of the GUI
October 16, 2015 at 6:59 am
Does your maintenance plan just do a full database backup, or does it take a log backup, rebuild the indexes and/or run DBCC CHECKDB as well?
John
October 16, 2015 at 7:03 am
Yeah it has maintenance clean up task after db backup but when u check history it says backup completed in 2 hrs.
October 16, 2015 at 7:18 am
Is that the job history or the backup history? What do you get if you run this?
SELECT
backup_start_date
,backup_finish_date
FROM msdb.dbo.backupset
WHERE type ='D'
AND database_name = 'MyDatabase'
Is the database in Full recovery mode, and if so how frequently do you take log backups, and is that frequency the same day and night?
John
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply