Home » Reply » Reply To: How to view SQL Server log file?

Reply To: How to view SQL Server log file?

Andrew Jackson ~ Modified: July 4th, 2015 ~ ~ 1 Minute Reading

Home › Forums › How to view SQL Server log file? › Reply To: How to view SQL Server log file?

July 4, 2015 at 4:52 am #317 Score: 0
Andrew Jackson
Moderator
1 pt

After the BLOBs deletion, The BLOB which gets deleted is not a part of the transaction log, hence unable to recover BLOB by just analyzing the transaction log. Therefore INSERT log record is need to manage as well as to recover the deleted BLOB from transaction log using fn_dblog.