For all operations, a SQL Server VM requires connectivity to the Azure Backup service, Azure Storage, and Microsoft Entra ID. This can be achieved by using private endpoints or by allowing access to ...

The Scripts in this repository is t configure logshipping as part of migration or disater recovery from an on-premises sql server or SQL Server on EC2 to RDS for SQL Server with the assumption that ...

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

Data loss can happen when you least expect it, whether from human error, system failures, or unexpected outages. That’s why having a reliable SQL backup strategy is essential if you want to protect ...

One of the major challenges that SQL Server admins face nowadays is corruption in MDF file. When a database is corrupted, it goes into the suspect state or you may fail to access the tables, stored ...

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...

Help! My SQL Server Log File is too big!!! Your email has been sent Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim ...

In an earlier blog entry, I talked about “Deprecated” code and I highlighted the fact that the BACKUP LOG WITH NO_LOG and BACKUP LOG WITH TRUNCATE_ONLY statements are no longer allowed in SQL Server ...