Results 1 to 7 of 7

Thread: last dump date

  1. #1
    Join Date
    May 2009
    Posts
    10

    Unanswered: last dump date

    Hi I am pretty new to sybase.
    I need to find last dump(backup) database date and
    last restore(load) database date for my sybase 11.9.2 server's database.
    Wht system table or command will help me?
    Like in sql server there is atable that shows history of last db backup or restore dates,is there anything here?
    Please let me know
    Thanks a lot

  2. #2
    Join Date
    May 2009
    Posts
    43
    If you have the MDA tables enabled then this information is in master..monOpenDatabases.

    You can find the last tran dump date in master..sysdatabases

  3. #3
    Join Date
    Mar 2008
    Posts
    96
    hi,
    There is a sysdatabases table in master database which keeps record for last dump information for every database. you can query this table as below

    select name,dbid,dumptrdate from sysdatabases where name = <db_name>

    hope this will be helpful

  4. #4
    Join Date
    May 2008
    Location
    Cambridge
    Posts
    26
    It sounds like you want the last actual database dump time as opposed to a transaction log dump time. As previously mentioned, if you have the MDA tables (aka monitoring tables) installed, then you can run the following query:

    select DBName, BackupStartTime from master..monOpenDatabases

    However, with regard to the last restore time, I'm not sure if you can get this from the mon tables or not. Best to look at the backupserver log file which will hopefully (for your sake) be in its default location which will be something similar to:
    $SYBASE/ASE-<version>/install/<backupservername>_BS.log

    Look for the latest:
    LOAD is complete (database yourdbname)
    in the log. Be sure it was the lastest load your found, not an earlier one.
    The dumps are also recorded here of course. Look for:
    DUMP is complete (database yourdbname)

    Regards

    Bob
    Last edited by harq; 06-02-09 at 17:01.
    Bob Holmes
    Sybase ASE/Replication Server Administrator
    Digital Data Safe - managed database services
    Email: bob.holmes@ddsafe.co.uk

  5. #5
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    The OP has 11.9.2 and I dont think MDA was introduced then. If Im right it was 12.5.x.

    Your best bet is to check the Backup Server errorlog and have some kind of a grep functionality.

  6. #6
    Join Date
    May 2008
    Location
    Cambridge
    Posts
    26
    Yeah, good point trvishi - I think you're right. Best bet IS in fact to go to the backupserver errorlog.
    Bob Holmes
    Sybase ASE/Replication Server Administrator
    Digital Data Safe - managed database services
    Email: bob.holmes@ddsafe.co.uk

  7. #7
    Join Date
    May 2009
    Posts
    10
    Thanks all for your reply

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •