April 3, 2002 at 8:35 am
My backup maintenance plans are not ending. Had this problem over the weekend and rebooted the server but it happened again last night. When I look at the database users, they are running something like
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 2AAF9BD4-BCAF-42B9-B72F-2D4DF741541F -To "it.helpdesk" -Rpt "d:\MSSQL7\LOG\DB Maintenance Plan36.txt" -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "E:\sqlbackup\SASIxp" -DelBkUps 7DAYS -BkExt "TRN"'
This is a SQL Server 7 database.
Has anyone else seen anything like this?
April 3, 2002 at 10:18 am
I'd double check that you have enough disk space free for it to complete, might also want to monitor to see if it's getting blocked by another process.
Andy
April 3, 2002 at 11:13 am
The drive has 25Gb of disk free - full backups are running around 4Gb and transaction logs from 1K - 1.3Gb so there should be plenty of space. There aren't any blocking locks in the database.
The other interesting thing about this problem is that SQL Server log has a completed message for the backup.
April 3, 2002 at 4:53 pm
This is the reason I resorted to scripts. But it may have something to do with what SP level your running, what is your SP level and have you checked the later SP's (if not running latest) to see if one fixes?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 3, 2002 at 5:37 pm
I've only seen it once, had to kill the sqlmaint to get it to stop. Overall I've been very happy with the maintenance plans.
Andy
April 5, 2002 at 1:52 pm
The problem is in the e-mail message we're sending to Operations. I executed the sqlmaint command and it gets through the backup successfully but hangs when it sends e-mail. We will script around this but are wondering if it's related to the security enhancements in Outlook and how sql mail will get around them.
Thanks for the help!
Jackie
April 5, 2002 at 2:18 pm
Bummer if that's true, had not thought about it. I've avoided Office SP1 just so I can use Outlook to send email from apps on my workstation. We've got an email service set up (a table you append to and it gets processed) that we're moving every to. Found a bug of some sort today in Outlook XP, doesn't like to create draft messages in HTML. Has worked fine over a year in 2000, broke in XP and not even an error. Depressing.
Andy
April 5, 2002 at 2:42 pm
Also could be a compatibility issue, saw a couple of articles on MS KB site about SQLMail/SQLVersion with Outlook versions.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply