Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

On SQL Server 2005 log report, everyday I receive the following message:

I/O is frozen on database databasename.

Is it serious ? How to resolve it ?

share|improve this question
What do you use for backups? Something like VSS? –  Thomas Stringer Jul 24 '12 at 12:28
The only time I've seen this in my own environment is when VSS-based backups have been running so that would be my guess too. –  georgeb Jul 24 '12 at 14:33
This is how certain file level backup systems (like VSS) ensure consistency of the backup, they explicitly freeze IO on the database, see A Guide for SQL Server Backup Application Vendors. You need to identify which such backup system is causing it, who installed it and why etc etc. –  Remus Rusanu Jul 24 '12 at 14:35
YES, you guys were right. It was VSS, which caused this messgae in SQL Server Log –  aasim.abdullah Jul 25 '12 at 12:32

1 Answer 1

VSS is being used to backup your database.

Edit: [Thanks Colin]

This causes the logged 'I/O is frozen' message. It is not serious. No need to resolve it.

Be warned, your database restore chain may be impacted, in which case it is serious. If you backup strategy is weekly full, daily diff, hourly tran per day - 8am -5pm; a daily snapshot VSS backup will cause your diff's to fail.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.