Month: March 2024

SQL Server log files

Anatomy of a SQL Server Transaction Log

March 19, 2024

Recently, we discussed the role of the recovery model in establishing how SQL Server manages database transaction logs. But what is the SQL Server log composed of? How does the logging process work? In this post, we will dissect the SQL Server transaction log to uncover its core anatomy. First, what is the transaction log?…
Read more

mixing sql backup strategies

The Risks of Mixing SQL Server Native Backups with Snapshot Technologies

March 8, 2024

As a DBA, one of the most critical aspects of managing SQL Server is ensuring the integrity and reliability of database backups. SQL Server’s native backup functionalities offer robust tools for securing your data, particularly for databases utilizing the full recovery model. However, mixing SQL Server native backups with disk or VM snapshots can lead…
Read more

Subscribe to Blog

TAGS
Recent
Database Administration
Script Library

2000 Mallory Lane
Suite 130-707
Franklin, TN 37067

© 2024 The SERO Group.