on 2010 Nov 09 1:06 PM
I've got a maintenance plan running that does a validation and then a backup using
backup database directory 'P:\\\\GKBackups' wait before start transaction log rename;
There seems to be something wrong with the database or something, because the backup file is 'not a valid database file', and it seems the event for the maintenance plan never finished (connections were still disabled; never got email).
Any thoughts?
SQLA 10.0.1.3835
UPDATE:
I did some logging, but I got NOTHING. The backup just never finishes. It never throws an exception either. I have absolutely nothing to go on. The strange thing is, though, that dbbackup.exe
will work, just the backup database
command will not.
Request clarification before answering.
If the backup didn't finish, then the file will be invalid. The last thing we do after the backup completes is update the header of the file to mark it as valid. What you need to find out is why the backup never finished.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
IIRC, I had some issues a while ago (with SA 10.0.1, can't remember the exact build) when using backup as part of a maintenance plan: AFAIK such a plan runs with the "WAIT BEFORE START" clause by default, and in case of (accidentally) long open trancactions, it prevented the backup to start at all... Manually removing that clause in the event handler solved the issue.
User | Count |
---|---|
50 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.