Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2006
    Posts
    13

    Unanswered: last Dump database date

    How can we see the last database dump date without seeing the log file ?

  2. #2
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    Which log file ? Backup Server Log shows it, and the dumpfile itself (LISTONLY, HEADERONLY options).

    Those of us who have scripts for db backups write a "succeeded/failed message" to history log file for the Server.

    Cheers
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

  3. #3
    Join Date
    Nov 2006
    Posts
    13

    Question

    Thank you for replying me.Actually I don't want to show the backup server log file and for list_only and headeronly options need the name and path of the dump file.I want a global variable or any system stored procedure or something like that which will show from isql, the last dump date.Hope you understand my point.

  4. #4
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    If you have the MDA tables enabled then this information is in master..monOpenDatabases:

    Code:
    [31] MYSRV.master.1> select DBName, BackupInProgress, LastBackupFailed, BackupStartTime from monOpenDatabases;
     DBName                         BackupInProgress LastBackupFailed BackupStartTime
     ------------------------------ ---------------- ---------------- -------------------
     master                                        0                0 Nov 30 2006 12:32AM
     sybsystemdb                                   0                0 Nov 30 2006  9:37AM
     model                                         0                0 Nov 30 2006 12:32AM
     tempdb                                        0                0 Nov 30 2006  9:37AM
     sybsecurity                                   0                0 Nov 30 2006  9:37AM
     sybsystemprocs                                0                0 Nov 30 2006  9:37AM
    ...
    Michael

  5. #5
    Join Date
    Nov 2006
    Posts
    13
    Thank you for your valuable suggession.But actually our ASE version is 11.9.2.

  6. #6
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    There is no global variable for this, even if there was, it woul dhave to be per database, and @@vars are specific to your current "use db".
    1 Yeah, the scripts you use to dump db should log to a history log.
    2 sysdatabases.dumptrdate contains the last dump tran date. For most of us who have mature sites, in order to reduce the recovery time in the event of a load db, we dump tran before the dump db. This ensures the dump db file has the smallest tran content. IF you were using this structure in your dump dbs, AND you have the tran set up for a full days worth, then the dumptrdate may be useful.

    Cheers
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

  7. #7
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    On older releases of Sybase

    use <db>
    go
    dbcc traceon(3604)
    go
    dbcc dbtable
    go
    Look for
    dbt_backup_start: Dec 7 2006 12:26PM
    dbt_pagelkprom=[lwm=200 hwm=200 pct=100 status=(0x0008 (LKPROM_PAGE), 0x0001 (LKPROM_SERVER)) seqno=1]
    dbt_rowlkprom=[lwm=200 hwm=200 pct=100 status=(0x0010 (LKPROM_ROW), 0x0001 (LKPROM_SERVER)) seqno=1]

    dbt_singleuser=0x0 dbt_seg=0x10004f629b0
    dbt_logsuspended=0
    dbt_repl_context=0x10004f634d0 dbt_repl_spin=0x1000030a5c0
    dbt_secondary_truncpg=00x0
    dbt_rep_gen_id=0
    dbt_dbcache=0 dbt_sysindcache=-1
    dbt_csysindcache=-1 ha_suspect_info=0x0

Posting Permissions

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