Category Archives: Transaction Log

Transaction log Information gathering

Posted on November 14, 2019 by Vinay

Here are the different ways to know the tlog file related information sys.dm_db_log_stats – Provide summary of tlog information SELECT * FROM sys.dm_db_log_stats(db_id()) sys.dm_db_log_info -DMV function for VLF information same as dbcc loginfo which is non documented by Microsoft. SELECT … Continue reading →

Posted in Others, Transaction Log | Tagged | Leave a comment

Smart Tlog Bkp

Posted on November 4, 2019 by Vinay

another great new feature for SQL Server 2017 is a smart backup with dmv sys.dm_db_log_space_usage this DMV provide log usage information using this we can plan to initiate the tlog backup and ensure to have tlog backup consistency and same … Continue reading →

Posted in Backup and Restore, Others, SQL Server 2017, Transaction Log, Troubleshooting, Whats New | Tagged , , , | Leave a comment

Error 9002

Posted on October 29, 2019 by Vinay

This is very important error whenever you see this error it is clear that your database has “TLOG FILE FULL” and this could result into maintenance job  failed or you system not respond properly. for update stats you get so … Continue reading →

Posted in Error Log, Others, Transaction Log, Troubleshooting | Tagged , , | Leave a comment

Day 15 Server Logs

Posted on May 15, 2018 by Vinay

There are 6 types of logs available for MySQL environment, Logs are important information for DBA to troubleshoot or understand the system. MySQL track the information in those logs. Following are the list of logs: Error Log (– start/stop/errors) Query … Continue reading →

Posted in Error Log, MySQL, Others, Performance Tuning, Transaction Log, Troubleshooting | Tagged , , | Leave a comment

LogReader agent failed

Posted on October 16, 2013 by Vinay

You may get an error on log reader agent failed with following error:   Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission. … Continue reading →

Posted in Replication, Transaction Log, Troubleshooting, What I learned today | Leave a comment

Denali — Day 6: indirect Checkpoint

Posted on May 6, 2012 by Vinay

Denali – Day 6: indirect Checkpoint I have already blog some information about checkpoint here As I have already blog about Checkpoint and how it works. Generally it works approximately every 1 minute(internal – default) . You could do this … Continue reading →

Posted in Denali, Disaster Recovery, Transaction Log | Tagged , , | Leave a comment

Restore fails with tail of log error

Posted on March 22, 2012 by Vinay

For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to restore earlier backup it may fail with following error Msg 3159, Level 16, State 1, Line 1 The tail of … Continue reading →

Posted in Backup and Restore, Transaction Log, Troubleshooting | Tagged , | Leave a comment

Last updated datetime of Sql Server files

Posted on January 18, 2012 by Vinay

*This is related to physical file size of a MDF or LDF file not internal allocation. One of our user asked that the ldf file is not changing, on checking the last modified date time, user was asking this. Its … Continue reading →

Posted in General, Internal, Transaction Log, What I learned today | Tagged , | Leave a comment

Day 2: Log file grown high cannot shrink log file.(available size in – negative)

Posted on November 29, 2011 by Vinay

Description:- Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user database has grown high and occupying most of its space. Please see the great blog post to know about … Continue reading →

Posted in Transaction Log, Troubleshooting | Tagged , | Leave a comment

Day 3: Transaction Log Backup job failed

Posted on November 3, 2011 by Vinay

Day 3: Transaction Log Backup job failed   Description:- One of our backup log job failed with following error:   Executing the query “BACKUP LOG [Navision] TO  DISK = N’E:\\Backup\\Navision\\Navision_backup_201110190800.trn’ WITH NOFORMAT, NOINIT,  NAME = N’Navision_backup_20111019080027′, SKIP, REWIND, NOUNLOAD,  STATS … Continue reading →

Posted in Backup and Restore, Transaction Log, Troubleshooting | Tagged , , | Leave a comment