Month: July 2023

olved stery July 8, 2023

olved steries #4 – SQL Won’t Shut Down!

Issue Introduction I was sent a quite an interesting email stating that SQL Server would not shut down. Attempting to stop the service via services or the SQL Server Configuration Manager resulted in a timeout with SQL Server still running. Trying to execute the shutdown with and without NOWAIT T-SQL command resulted in the same, […]

Read article

DMVs July 3, 2023

model_msdbdata and log, model_replicatedmaster and log – What are they?

There was a question that came up on the MCM mailing list about what are these files: model_msdbdata.mdf, model_msdblog.ldf, model_replicatedmaster.mdf, model_replicatedmaster.ldf? It was pointed out that the files don’t show up in the typical DMVs and seem to not really be used at the moment. These are the databases used as the basis for the […]

Read article