Tell me more ×
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.
up vote 2 down vote favorite

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
3  
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_dba Jul 24 '12 at 14:33
2  
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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.