Tag: SQL Server
-
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…
Michael Paul | @micoolpaul 