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 ?
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 only takes a minute to sign up.Sign up to join this community
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.