Backup Failures

3266 :
The backup data in 'ThursdaylogsAM' is incorrectly formatted. Backups cannot
be appended, but existing backup sets may still be usable.
3041 :
BACKUP failed to complete the command BACKUP LOG [GIS] TO [ThursdaylogsAM]
WITH INIT , NOUNLOAD , NAME = N'ThursdaylogsAM', SKIP , STATS = 10,
DESCRIPTION = N'ThursdaylogsAM', NOFORMAT DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='GIS'and
type!='F'
I have a daily backup procedure that started to fail. It was created by
another technician so I don't know if he copied it or used a Wizard to create
it. For no apparent reason, it fails with thi smessage but only on certain
days. There is an individual procedure for each day of the week and other
than the name of the directory/file being written to, all instructions are
the same. i can't figure this one out!!!
Do you see any errors in the sql error log? And the application logs at the
same time? Assuming this was run perhaps as a sqlagent job, does the
sqlagent.out have any error message?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
sql

Backup Failures

3266 :
The backup data in 'ThursdaylogsAM' is incorrectly formatted. Backups cannot
be appended, but existing backup sets may still be usable.
3041 :
BACKUP failed to complete the command BACKUP LOG [GIS] TO [ThursdaylogsAM]
WITH INIT , NOUNLOAD , NAME = N'ThursdaylogsAM', SKIP , STATS = 10,
DESCRIPTION = N'ThursdaylogsAM', NOFORMAT DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='GIS'and
type!='F'
I have a daily backup procedure that started to fail. It was created by
another technician so I don't know if he copied it or used a Wizard to create
it. For no apparent reason, it fails with thi smessage but only on certain
days. There is an individual procedure for each day of the week and other
than the name of the directory/file being written to, all instructions are
the same. i can't figure this one out!!!Do you see any errors in the sql error log? And the application logs at the
same time? Assuming this was run perhaps as a sqlagent job, does the
sqlagent.out have any error message?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Backup failure Error Log Messages

I have not been able to find any details about backup failures for
MSSQL 2000. I am researching the following:
1. when a backup fails at a certain point during the process does the
backup:
A. stop there having recorded some details?
B. quit without backing up any of the data it already processed?
C. skip the data it cannot read and move on?
2. Does the error log record any of the details above? For instance, if
there is a table that the backup could not write to .bak, does the
error log report exactly where the error was?

I need a way to obtain a Backup Exception 'Report' that when a backup
fails it can tell me what did not get into the .bak file. I would
prefer automatic notification. Our Oracle DBs have something setup
that can be run when a piece of the DB does not get backed up letting
the Oracle DBA know where there are issues.

Thank you,
StephanieHi
1. B
2. If it is a write failure, yes it will be in the SQL Log. If it is data
corruption, it is in the SQL Log.

For a backup to fail, due to internal SQL Server problems is very very rare,
and I have not seen it on a clean database before.

Most failures are caused by running out of disk space or anti virus messing
around on the file when SQL is trying to write to it.

Regards
----------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@.epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Stephanie" <stuttle@.centene.com> wrote in message
news:1123710578.824686.208370@.g47g2000cwa.googlegr oups.com...
>I have not been able to find any details about backup failures for
> MSSQL 2000. I am researching the following:
> 1. when a backup fails at a certain point during the process does the
> backup:
> A. stop there having recorded some details?
> B. quit without backing up any of the data it already processed?
> C. skip the data it cannot read and move on?
> 2. Does the error log record any of the details above? For instance, if
> there is a table that the backup could not write to .bak, does the
> error log report exactly where the error was?
> I need a way to obtain a Backup Exception 'Report' that when a backup
> fails it can tell me what did not get into the .bak file. I would
> prefer automatic notification. Our Oracle DBs have something setup
> that can be run when a piece of the DB does not get backed up letting
> the Oracle DBA know where there are issues.
> Thank you,
> Stephanie