SQL Server Performance Forum – Threads Archive

Check Last Uploaded Trans Log

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

---

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.

---

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.

---

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

---

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.

---

]]>