Take the 2-minute tour ×
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
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
add comment

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.