Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

determine last load of database when using shared backup s..

 
   Database Forums (Home) -> Sybase RSS
Next:  set up multi instance cluster  
Author Message
wombarrapete

External


Since: Aug 19, 2007
Posts: 1



(Msg. 1) Posted: Sun Aug 19, 2007 6:44 pm
Post subject: determine last load of database when using shared backup server
Archived from groups: comp>databases>sybase (more info?)

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.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Determine Last Dump Load? - Dear all Is there a way, beside looking into the backup servers log, to determine the last LOAD of a DUMP into a database? ... kind of "sp_whenWasTheLastDumpLoaded" .. Regards Oliver

Problems to load a dump into Database - Hello all I am not able to load a dump into my new database from an existing database. The command I am using ist: load database <databasename> from <path_to_dump>" The errors I get are: ===============================================...

how do i load a database split in to many files - Hi, my backup script currently uses the "stripe on" clause to backup my database into two files. Then it uses gzip to compress the files. Each file is 200 MB. I want to restore this two files does anyone know how to restore assume they are call...

shared memory - Why do we need to set shared memory at 64 MB for installation of ASE-12_5.

availability of sybase 15 shared libraries libsybct_r.so and - I have just received a new version of a third-party server that has been linked with the sybase 15 shared libraries. We don't have sybase 15, we are still on sybase 12. Hopefully the executable will still work provided that we can get hold of copies of..
   Database Forums (Home) -> Sybase All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]