SQL Server Performance

Check Last Uploaded Trans Log

Discussion in 'SQL Server Log Shipping' started by travistan, Aug 10, 2006.

  1. travistan New Member

    Hi ,

    I have a process which generate a transaction logs from server A and restore the logs to Server B by batch. The process will transfer the logs every 15 minutes and restore the logs once a day in the mid night.

    Sometimes the process of restore might failed due to certain reason. But I am not sure what is the last file restored. How can I check what is the last files I restore instead I manual restore one by one to trace.

    Thanks ,
    Travis
  2. satya Moderator

    Are you using Log shipping in this case?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  3. deepakontheweb New Member

    You can check "Restore logs " from SQL Server error log file for it.. Also you can query below MSDB db tables:

    restorehistory
    The restorehistory table contains one row for each restore operation. This table is stored in the msdb database.


    restorefile
    The restorefile table contains one row for each restored file, including files restored indirectly by filegroup name. This table is stored in the msdb database.


    backupset
    Contains a row for each backup set. This table is stored in the msdb database.




    Deepak Kumar
    MVP, MCDBA - SQL Server

    Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.
  4. travistan New Member

    Hi Deepak Kumar ,

    Thanks for the information ..
    Emm .. from MSDB table I also not able to know what is the last "actual filename" I upload right ?

    Thanks ,
    Travis
  5. satya Moderator

    What stated above is to check the SQL error log where it gives the filename information too.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page