November 12, 2003 at 1:15 am
Hi My Probkem Is That
I have Create A Full Database Backup Plan
No Log Backup and no Problem Correction or Space Reclaiming
The Plan has to delte files Older Than 1 Day
When I run The Job created By the Plan
It Backs up all Data bases and freezes even
if the backup directoy was empty
the services of sql and sql agent have full
administrator rights
I Can Not even kill the process
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 3FF36168-D48B-4F4C-8BAA-4A77FD15B229 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB -UseDefDir -DelBkUps 1DAYS -BkExt "BAK"'
November 13, 2003 at 3:19 pm
Seems to be the files gets hung...why don't you try to backup the same db to to the path defined in the maint plan just to verify. If it does go thro' manual backup, u just need to delete and recreate the maint plan. Sometimes when u make changes to already craeted paln there are some problems with it. Good luck.
November 14, 2003 at 8:33 am
Maintenance plans are executed by the agent do you think that could have anything to do?
Does the job run normally when scheduled?
Right click on DB and choose full backup and see if that hangs too.
This might have little to do but
You may have noticed some persistence about backups
that deletes files older than one day
Mike
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply