Category Archives: Transaction Log

Day 15 Server Logs

Posted on May 15, 2018 by

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

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

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

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

*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

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

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

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

Posted on November 2, 2011 by

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 … Continue reading →

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

Transaction Log Internals

Posted on June 22, 2011 by

Transaction Log : >> Transaction log is tracks transaction on that database. >> There should be at least one  transaction log (ldf) file for every database. >> Transaction log is always write in sequential manner , Only at redo state … Continue reading →

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

Difference between Mirroring and Log Shipping

Posted on August 7, 2010 by

It’s been quite some time that I blog, Sorry about that I was busy with my movement from USA to India and changed my job  part of life ,okay  back to India (Pune). Lastly I wrote a blog on High Availability … Continue reading →

Posted in Disaster Recovery, High Avaliability, Log Shipping, Transaction Log, What I learned today | Tagged , | Leave a comment