SQL Server Database Mail & Agent Alerts are a free, easy way to get notified of corruption, errors & job failures before users report problems.…
Category: SQL Server Administration
I came across this error recently on a VM with multiple SQL Server instances installed. Initially a SQL 2016 instance had been installed & some…
This trick is useful if you need to “pretend” that a named instance is the default instance, e.g. to connect a poorly coded app that…
I administer SQL Servers that have several log shipping jobs, enough that manually disabling & enabling them (e.g. for maintenance windows) is tedious & time…
Following on from my previous post about Instant Initialization of database files, SQL Server 2016 and above allows you to set this up as part…
Some time ago, I encountered an apparently failing backup job on a SQL Server 2008 R2 instance. The job used the Back Up Database Task…
Aim: To allow remote connections to a SQL Server named instance. These steps are useful as a basic troubleshooting guide when you are experiencing problems connecting…
Aim: Grant the relevant permissions to the SQL Server service account to allow for Instant Initialization of database files. Instant Initialization allows space to be…