Home » Blog » Topic » How to view SQL Server log file?

How to view SQL Server log file?

Stephen West ~ Modified: June 27th, 2015 ~ ~ 1 Minute Reading

Home Forums How to view SQL Server log file?

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #258 Score: 0
    Stephen West
    Moderator
    4 pts

    Is it possible to view Log File in SQL Server? I want to see all the DML commands given to my database

    #260 Score: 0
    Kerry Morris
    Moderator
    33 pts

    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.

    #283 Score: 0
    Stephen West
    Moderator
    4 pts

    Does the tool recover all the deleted data as well?

    #286 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    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.

    #305 Score: 0
    Kerry Morris
    Moderator
    33 pts

    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 file

    Note: 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.

    #316 Score: 0
    Mariya Beckham
    Moderator
    2 pts

    Is there any option to identify whether the Transaction occurs with BLOB (Binary Large Object) ?

    #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.

Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.