SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?


One of my clients contacted me and asked me the reason for this message? And my first reaction was, did you keep the database in very cold weather? It might be freezing over there and that’s why SQL is saying:   “I/O is frozen on database” and “I/O was resumed on database”? Did you check the air conditioner temperature?

Jokes apart. Let’s discuss the message. Let me paste the complete message and I am showing only one such combination.

Message 1I/O is frozen on database model. No user action is required. However, if I/O is not resumed promptly, you could cancel the backupMessage