Tag: SQL Server
-
Microsoft SQL Server 2025 + Veeam Data Platform = Improved Scalability
Hey everyone, Let’s kick this off by highlighting that as of this moment, Microsoft SQL Server 2025 has not yet been validated for the Veeam Data Platform, as it was only made GA yesterday the 18th November 2025, so the information I’m providing here is in preparation for the inevitable support when it’s passed through…
-
Data Protection Considerations: Digesting the SQL ConstantCare Report
For those of you who don’t spend much time or have much experience with SQL Server, Brent Ozar is a well-known and respected Microsoft SQL consultant. In addition to consultancy and training services, Brent Ozar offers tools such as the First Responder Kit, and a SQL Server monitoring service called SQL ConstantCare. SQL ConstantCare is…
-
SQL Server 2019 – TDE DB Recovery Errors, Log Shipping & CU16
If you’re using SQL Server 2019, Transparent Data Encryption, and compressing your database backups, you might be in for a shock. Microsoft released a KB detailing a known bug preventing the restores of these backups. Whilst the latest CU addresses this bug, there’s some important caveats to understand and plan for accordingly. Read this blog…
-
Troubleshooting Tip: Recovering Access to a MSSQL Database
I was recently helping a customer create a SQL database backup for a support ticket and noticed that they had an interesting SQL Server configuration. There was only a single account with sysadmin rights, the sa account, but this account wasn’t allowed to sign in. The SQL Server was domain joined but there was just…
Michael Paul | @micoolpaul 