Aim: To restore a Long-Term Retention (LTR) backup of an Azure SQL Database after the associated SQL Server has been deleted. Microsoft’s documentation states that…
Tag: SQL Server Administration
Following on from my last post, I had decided that automating the step to stop SQL Server would be a better option than relying on…
At home, my test environment for SQL Server runs on a Windows 10 PC. It’s the same PC that I use to do a bunch…
Applying a Lock to an Azure SQL Server can protect the databases in that SQL Server because child resources inherit locks from their parent, but…
Aim: To capture SQL Agent job history to a table. Following on from the previous blog post about adjusting the size of the SQL Agent…
Aim: To adjust the size of the SQL Agent job history log to retain more or less history as required. On some SQL Servers with…
Aim: Schedule daily backups of an on-premises SQL Server database & copy it to an Azure virtual machine as part of a Disaster Recovery process. In…
Aim: Create a virtual network & machine in Azure to which on-premises SQL Server databases can be backed up as part of a Disaster Recovery process.…
Aim: Set service accounts for SQL Server after installation. In Server Manager, create a new user with a strong password for the SQL Server instance service.…