How to view SQL Server log file?
- This topic has 6 replies, 4 voices, and was last updated 9 years, 4 months ago by .
-
Posts
-
You can try third party solutions available online to view log files of SQL server. One such tool is available here http://www.systoolsgroup.com/sql-log-analyzer.html SQL Log Analyzer which allows you to preview all activities of .ldf file and helps you in reading and analyzing distinct transactions like delete, modify, insert.
So, with the help of this tool you can easily view all the DML commands given to your SQL database.
You can use the fn_dblog() function to see the DML commands which you have given to your database, But the procedure of this function is too long and time consuming. So it is better to use a third party tool.
Stephen West, yes you can recover the delete records as well, for this purpose, you need to browse the LDF & MDF file in the software and then select the scanning option. Software will recover the deleted records for you and offers you 3 different ways to save the recovered data:
1. Save as SQL Server database
2. Save as SQL Server compatible SQL scripts
3. Save as CSV fileNote: You need to have LDF & MDF file in order to recover deleted records. Incase, any of these files is missing then you can’t perform the recovery of deleted data.
Is there any option to identify whether the Transaction occurs with BLOB (Binary Large Object) ?
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.
- You must be logged in to reply to this topic.