Microsoft SQL Server application is perhaps the greatest wave in the social database the board framework and handles gigantic database in a well-organized way.
Yet, Digital Crimes Can Takes Place In SQL Server Too!!!!
These days, Ex-representatives or programmers purposefully alters the estimations of databases so as to harm the association resources. What's more, it ends up hard to break down who is the guilty party physically. Subsequently, Organizations keep running into enormous inconvenience.
Hang On!! There Is A Good News
In SQL Server, there is an exchange log document that tracks all exchanges and changes in the database made by each exchange. By perusing this document, the client can check who erased information from a table in SQL Server database. Additionally, it is utilized to examine SQL Server Transaction Log for legal investigation so as to check each log subtleties in a nitty-gritty way. To put it plainly, with SQL Log document it turns out to be anything but difficult to discover which question performed on which table at what time.
Here, we are going to answer how to see the log record of SQL Server by utilizing different workarounds. Simply experience this article once and see how to peruse exchange log record in Microsoft SQL Server 2017/2016/2014/2012/2008/2008 R2/2005.
Step 1: We have a table named ‘Employee’. So, first, view the values of the table using the following T-SQL.Select * from employee.
Select * from employee.
Step 2: Afterward, alter the table data using the update command. For this, execute the query;Update employee set department ='IT' where emp_name = 'jeevan'
Update employee set department ='IT' where emp_name = 'jeevan'
Step 3: Again, view the table values using the Select Query. Now, you can see a modified table.
Step 4: Run the fn_dblog function according to the need. Here, we execute the query to check out the time when update operation was executed.
Select [Begin Time], [Transaction Name] from fn_dblog(null , null) where [Transaction Name] = ‘Update’
Step 5: In a situation, when you want to analyze all the logs such as Delete etc. , then run the following T-SQL query.
Select [Begin Time], [Transaction Name] from fn_dblog(null, null)
Try SQL Log Analyzer Software to easily view or read SQL Log (LDF) file and create new Database successfully.