Hi - I wonder how you determine when a particular server..database was
loaded if multiple servers are sharing a single backup server ?
ie: the log shows the following type of entries :
Apr 16 11:58:47 2007: Backup Server: 6.28.1.1: Dumpfile name
'abc_PROD1' section number 1 mounted ...'
Apr 16 11:58:51 2007: Backup Server: 4.58.1.1: Database abc: 178206
kilobytes LOADed.
Apr 16 11:58:55 2007: Backup Server: 4.58.1.1: Database abc: 356538
kilobytes LOADed.
Apr 16 11:58:58 2007: Backup Server: 4.58.1.1: Database abc: 534870
kilobytes LOADed.
Apr 16 11:59:02 2007: Backup Server: 4.58.1.1: Database abc: 712818
kilobytes LOADed.
however if you have 5 DEV servers all with a database named 'abc' and
all sharing the single backup server ... how do you determine when
DEV1..abc was last loaded when all the backup server log shows is the
originating dumpfile name 'abc_PROD1' but not the destination
servername anywhere in the load statement printed in the log ?
(can you) do you have to push that line into the log yourself via your
own scripts ?
ie: about to load 'DEV1..abc ......'
cheers
pete
>> Stay informed about: determine last load of database when using shared backup s..