Disk full on log file disk is a bad thing. Often it helps when schrinking then database log file. It is only a problem when database is in Full recovery model. A reason why schrinking isn’t possible could be that backup is missing. So I needed a script to tell me when last backup is… Læs mere I cannot schrink database log
Måned: januar 2022
Running sessions
Often when a server seems to work slow or if I want to see what my store procedure is doing now, I use the “Running sessions” script. It helps me to get a fast overview of what are the SQL Server doing right now. Also blocking sessions are showed and if I uncomment the two… Læs mere Running sessions