LSN Archives - SQLServerGeeks

SQL Server – SQL Server has detected an unreported OS/hardware level read or write problem on page (1:74098) of database 10

September 21, 2013September 21, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Dear Friends, Sometime back while auditing error logs in one of the SQL Server instances I came across following message; SQL Server has detected an unreported OS/hardware level read or write …

SQL Server CHECKPOINT also generates LSNs in Log file

October 17, 2011October 9, 2014 - by Amit Bansal - 2 Comments.

Hi Friends, In one of my recent training, one participant had an understanding that Log Sequence Numbers (LSNs) are only generated by user transactions / user activity. Well, that’s not true. …

SQL Server: Auto-Truncate Log in Full Recovery Model

March 30, 2011August 28, 2014 - by admin - 9 Comments.

Auto-Truncate Log in Full Recovery Model FULL Recovery model: This means that all database changes are fully logged and ideally the log records should stay in the log file until the …