Category Archives: Transaction Log

Day 15 Server Logs

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

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

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

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

*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)

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

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)

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

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

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