A very interesting question popped up today: what happens when a SQL Server instance is restarted?
When an instance of SQL Server is shutdown (i.e. on the way to be restarted) what happens is:
all databases have checkpoints
all SQL Server Agent jobs are terminated and the Agent is shut down
all database files are released to the OS,
Continue reading […] What happens when a SQL Server instance is restarted […]