SQL Server Performance Forum – Threads Archive
Where is LSN details stored?
I am facing the problem which applying the transactions log during the full database restore. One time I was getting the error that it was too early to apply the transaction logs and second time it was mentioning it was too late to apply. So my question: 1. Where does the Database store the LSN details so that we could know which Transaction log contains which LSNs. Awaiting eagerly feedback from my expert SQL server Gurus. Regards, Viral ShahKindly don’t duplicate posts. I’ve deleted the other one.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
The LSN in the boot page is used to identify the active portion of the log. A database file .mdf would contain a checkpoint LSN as at the last backup, whereas it should contain a later LSN (the last checkpoint before the failure). This LSN would be used in determining the active portion of the log.
Refer to the books online for the topic Transaction log architecture. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Satya, thanks for the update. SO the details u mentioned can be queried ? or can we see in the any of the log files? My basic question was is the LSN -Transaction log relation info available in some tables ? For e.g. in oracle it is available in v$logfile Regards, Viral shah
quote:Originally posted by satya
The LSN in the boot page is used to identify the active portion of the log.
A database file .mdf would contain a checkpoint LSN as at the last backup, whereas it should contain a later LSN (the last checkpoint before the failure). This LSN would be used in determining the active portion of the log.
Refer to the books online for the topic Transaction log architecture. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Refer to the books online for the topic Transaction log architecture. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Until version 6.5 SYSLOGS is the system table which contains Transaction log details and from SQL ver. 7 onwards it has been removed; no replacement. The database log is now an operating system file. Remove all references to syslogs. To view transaction log, you can query the syslogs system table for SQL Server 6.5, or run DBCC LOG statement for SQL Server 7.0/2000. To view the transaction log you must depend on the third party tools like APEXSQL- Log navigator or Lumigent’s Log Explorer. Articles for your reference:
http://www.sql-server-performance.com/lockwoodtech_log_navigator_spotlight.asp
http://www.databasejournal.com/features/mssql/article.php/1443371 Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>