- Follow Vinay Thakur on WordPress.com
Blog Hits
- 115,078 hits
Categories
- Add/remove (9)
- AI (4)
- Automation (1)
- Azure (4)
- Backup and Restore (15)
- Basic (14)
- BI (3)
- BIGDATA (6)
- Books (6)
- Bug (7)
- Cloud (7)
- Computers and Internet (29)
- Containerization (2)
- Database System (3)
- DB Design (3)
- DeadLock (3)
- Denali (36)
- DevOps (1)
- Disaster Recovery (18)
- DMV (6)
- Docker Swarm (2)
- Error Log (8)
- Experts (9)
- FileStream (1)
- Free Stuff (7)
- Future DBA (17)
- General (32)
- High Avaliability (23)
- History (3)
- Imp dates (3)
- Index (5)
- Installation (14)
- Internal (13)
- Isolation Level (2)
- Kubernetes/Docker/Container (8)
- Limitation (9)
- Linux (1)
- Lock/Blocking (7)
- Log Shipping (1)
- Memory (6)
- Migration (3)
- MongoDB (6)
- MySQL (26)
- News (4)
- NoSQL (10)
- Open Source (2)
- oracle (1)
- Others (104)
- Performance Tuning (26)
- Personal (5)
- Powershell (33)
- Python (2)
- RDBMS (8)
- Replication (20)
- Security (1)
- Software (4)
- sql 2016 (10)
- Sql server 2014 (2)
- SQL Server 2017 (9)
- SQL Server 2019 (6)
- SQLonLinux (8)
- SSRS (1)
- TempDB (5)
- Tool (14)
- Training (2)
- Transaction Log (13)
- Troubleshooting (50)
- vNext (4)
- Webcast (9)
- What I learned today (77)
- Whats New (47)
- Whitepapers (9)
Archives
- April 2020 (3)
- January 2020 (2)
- December 2019 (1)
- November 2019 (9)
- October 2019 (4)
- September 2019 (1)
- August 2019 (1)
- March 2019 (2)
- February 2019 (2)
- January 2019 (5)
- December 2018 (6)
- October 2018 (2)
- September 2018 (7)
- July 2018 (3)
- May 2018 (25)
- February 2018 (1)
- January 2018 (2)
- August 2017 (2)
- May 2017 (2)
- April 2017 (1)
- March 2017 (2)
- February 2017 (1)
- October 2016 (2)
- September 2016 (9)
- May 2016 (1)
- April 2016 (1)
- January 2016 (2)
- December 2015 (1)
- July 2015 (1)
- May 2015 (1)
- December 2014 (1)
- February 2014 (2)
- October 2013 (3)
- June 2013 (1)
- May 2013 (1)
- January 2013 (1)
- October 2012 (1)
- September 2012 (3)
- August 2012 (1)
- July 2012 (2)
- June 2012 (1)
- May 2012 (31)
- April 2012 (3)
- March 2012 (3)
- February 2012 (3)
- January 2012 (2)
- December 2011 (4)
- November 2011 (33)
- October 2011 (1)
- September 2011 (1)
- August 2011 (4)
- July 2011 (1)
- June 2011 (5)
- May 2011 (2)
- April 2011 (31)
- March 2011 (3)
- January 2011 (1)
- November 2010 (3)
- October 2010 (1)
- September 2010 (1)
- August 2010 (3)
- June 2010 (2)
- May 2010 (4)
- April 2010 (4)
- January 2010 (10)
- December 2009 (3)
- November 2009 (2)
- October 2009 (11)
- September 2009 (7)
- August 2009 (5)
- July 2009 (8)
- June 2009 (4)
- May 2009 (6)
- March 2009 (1)
- September 2008 (1)
- August 2008 (1)
- July 2008 (7)
Category Archives: Transaction Log
Transaction log Information gathering
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
Smart Tlog Bkp
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
Error 9002
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 Errors, TrasactionLog, Troubleshooting
Leave a comment
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 MySQL, Performance Tuning, TrasactionLog
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
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 Checkpoint, Disaster Recovery, Troubleshooting
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 Errors, Troubleshooting
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 General, Internal
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
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 Errors, TrasactionLog, Troubleshooting
Leave a comment