Post reply

Which table contains the name and location of "rollback" file

  • September 13, 2007 at 8:35 pm

    #69178

    Hi,

    I am troubleshoting some log shipping issues and trying to find a system table that keeps the information about the name and location of the "rollback" file for databases which are in standby mode.  I've searched through some system tables and could only find .mdf and .ldf files information.

    Anyone has an idea?

    Thanks.

  • September 14, 2007 at 6:30 am

    #733739

    There is no table  which will provide rollback details to you. Pls check the system tables in the MSDB tables. Where there is a logshipping tables exist it will have a entry for all the last files transferred.

     

  • September 14, 2007 at 6:39 am

    #733747

    Hi,

    As far as I know, it's not configurable, and it'll be in the copy destination directory with the name of the last restoring log backup file.

    -- Erik http://blog.rollback.hu

  • September 16, 2007 at 6:19 pm

    #733990

    Sorry, I probably did not put it clear.  I am not interested in the log backup files, but I am looking at the temp file which allows to keep databases in stanby mode and be able to read it as well as apply future log backups:

    STANDBY = {undo_file_name|@undo_file_name_var}

    So, ones the databases is restored in standby mode, is there a table which contains the information where(which folder) the undo file was put to and what was the name of the undo file for a particular database?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply