recovering-data-from-the-sql-server-transaction-log 
Scalegrid
DECEMBER 9, 2019
However, when the crashed master comes back, you may find that it has transactions that are not present in the current master (which was previously a slave). However, discarding a server like this is expensive and inefficient. Why Is It Important to Detect Extra Transactions on the Recovered Master? In a MySQL 5.7
Percona
SEPTEMBER 19, 2023
In the world of data backup and security, physical backups play an extremely important role. This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. In addition to databases, the backup can include any related files, such as log or configuration files.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
JANUARY 20, 2022
All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. Performance issues from repeated shrinking of the transaction log. Basic Terminology Around Logging.
Scalegrid
MARCH 8, 2024
Data loss or corruption can be daunting. This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity.
SQL Performance
SEPTEMBER 17, 2019
Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.
SQL Server According to Bob
NOVEMBER 8, 2016
Note: We received feedback that there was some confusion on us calling this functionality “tail of the log caching” because our documentation and prior history has referred to the tail of the log as the portion of the hardened log that has not been backed up. Create / Alter Database … LOG ON.
Percona
AUGUST 30, 2023
These days, “Data is king,” and a lot more. Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. Any organization that uses personal and other sensitive data must have a firm, proven plan for business continuity in the event of a disaster or cyberattack.
Expert insights. Personalized for you.
160 
Let's personalize your content