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…
-

Veeam & SQL Server 2012, The Approaching End of Life & How to Migrate
Microsoft SQL Server 2012 goes end of life in July 2022, but did you know that a lot of Veeam installations are still using this database? In this blog post I’ll provide information on how to deploy a new SQL Server instance and migrate your database, then tidy everything up!
-
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…
-

Veeam Backup Service Fails to Start – AKA How I broke my lab this time…
It feels like everyone is always trying so hard to be perfect, I’m certainly not! But I’m happy to learn from and share my mistakes. I was messing about recently with Veeam Disaster Recovery Orchestrator and made some changes to my lab, and all was fine when I shut down. A few days later I…
-

Database Considerations: Veeam Backup & Replication / Veeam ONE on Windows Server 2022 – Part One
Veeam v11a is now available in RTM, bringing support for Windows Server 2022 amongst its many other features. If you’re planning a new deployment however, you’ll want to read on…
-

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…
