patternsqlMinor
I/O is frozen on database databasename
Viewed 0 times
databasefrozendatabasename
Problem
On SQL Server 2005 log report, everyday I receive the following message:
Is it serious ?
How to resolve it ?
I/O is frozen on database databasename.Is it serious ?
How to resolve it ?
Solution
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.
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.
Context
StackExchange Database Administrators Q#21386, answer score: 3
Revisions (0)
No revisions yet.