April 10, 2002 at 10:06 am
I've recently setup a new SQL Server and created a database with some default jobs we use. The Append Backup job which gets run every hour is however failing. This jobs works fine on all our other SQL boxes.
Heres the job detail:
BACKUP LOG [IMS] TO [LOG IMS]
WITH NOINIT , NOUNLOAD , NAME = N'DB1a - IMS Append Log Backup',
NOSKIP , STATS = 10, NOFORMAT
And the error I get is:
Server: Msg 3266, Level 16, State 1, Line 1
The backup data in 'LOG IMS' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
Any ideas why? I can't find any info on the web regarding this.
thanks
April 10, 2002 at 11:26 am
I'm not sure if this is the same error, but I used to get these on appends periodically. I deleted the file and it recreated it and it worked the next time.
I stopped using appends for this reason and setup jobs to handle each log file separately.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 10, 2002 at 6:14 pm
On your first backup also are you doing a FORMAT for the media with INIT.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 10, 2002 at 7:11 pm
June 20, 2006 at 9:24 am
I had the same issue, so I deleted and created a new backup device then ran the job with the "Format" option. I was then able to run it with "NOFORMAT". I also do not append.
Tim C.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply