Lately our BE is asking us to insert overwriteable media after our nightly job starts. There is nothing on the alert dialog about this, but it seems that it has run out of tape and is asking for another one to continue the backup.
I have had to cancel the backups each time as we don't have spare tapes but i would like to know what has been backed up to the point it sends the Alert but can't figure out how to do this. We have logging turned on at the Directory level.
If I look thru the job log, the "Set Information" for each parent item being backed up has a "Backup Started" and "Backup completed" which, to me, indicates the set was successfully backed up.
There is one backup set called "\\SQLSERVER\D: SQL" which is a list of files on our SQL Server which need to be backed up. The backup set has a "Backup started" and "Backup Completed" line, but half-way thru the list of directories in the Job Log, it shows this:
....
....
Directory \Program Files\BackOffice\Solomon\ES
Directory \Program Files\BackOffice\Solomon\EventLog
Directory \Program Files\BackOffice\Solomon\EventLog1
Directory \Program Files\BackOffice\Solomon\FD
Directory \Program Files\BackOffice\Solomon\FD65
Directory \Program Files\BackOffice\Solomon\FP
Directory \Program Files\BackOffice\Solomon\FP65
Directory \Program Files\BackOffice\Solomon\FP65\IO_DATA
Directory \Program Files\BackOffice\Solomon\FP65\SysData
Directory \Program Files\BackOffice\Solomon\FS
Directory \Program Files\BackOffice\Solomon\GL
Directory \Program Files\BackOffice\Solomon\GS
Directory \Program Files\BackOffice\Solomon\Help
---------------------------------------------------------------------------------------------
Drive and media mount requested: 2/14/2007 3:01:54 AM
Drive and media information from media mount: 2/14/2007 12:11:28 PM
Drive Name: DELL VS160
Media Label: JLRX01- Wednesday
Media GUID: {26d9fca4-ab53-4001-b7e0-88992e2d5146}
Overwrite Protected Until: 2/20/2007 12:11:28 PM
Appendable Until: 1/1/1900 11:00:00 AM
Targeted Media Set Name: Daily Backup
---------------------------------------------------------------------------------------------
Backup set #5 on storage media #2
Directory \Program Files\BackOffice\Solomon\Import
Directory \Program Files\BackOffice\Solomon\IN
Directory \Program Files\BackOffice\Solomon\inspectr
Directory \Program Files\BackOffice\Solomon\IQ
Directory \Program Files\BackOffice\Solomon\IR
Directory \Program Files\BackOffice\Solomon\LC
Directory \Program Files\BackOffice\Solomon\MC
Directory \Program Files\BackOffice\Solomon\MDAC
Directory \Program Files\BackOffice\Solomon\OM
Directory \Program Files\BackOffice\Solomon\OU
Directory \Program Files\BackOffice\Solomon\PA
Directory \Program Files\BackOffice\Solomon\PO
Directory \Program Files\BackOffice\Solomon\PR
Directory \Program Files\BackOffice\Solomon\RE
Directory \Program Files\BackOffice\Solomon\Renown
....
....
It looks as tho another tape was inserted into the drive and the backup completed, but this is impossible as I cancelled the backup when it showed the Alert.
Can someone explain what is going on?
I can email the Job Log to anyone who can help. Thanks
BE10d on Win 2003 Server SP1. Backup starts each night at 9pm.