I/O is frozen on database. No user action is required

19 August,2013 by Jack Vamvas

I’m receiving the I/O is frozen on database error :

I/O is frozen on database DB_NAME. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.
I/O was resumed on database DB_NAME. No user action is required.

 

What causes this error message?

I/O on the database is frozen in order for any backup service using Virtual Device Interface (VDI)  and commiting a sql  snapshot backup.

Examples of programs using this method are: Volume Shadow Copy (VSS) and Data Protection Manager (DPM).

The aim of the sql snapshot backup is to create an instantaneous copy of the data.  This allows consistency with all the files in the snapshot backup sequence.

From a backup and restore perspective – a SQL snapshot backup holds the same functionality. It is possible to use a SQL snapshot backup as part of a SQL restore sequence with other files that are not snapshot backups.

To check if a backup is a snapshot , check the is_snapshot column on Backup history for a single SQL Server database

Applications should be designed in a way to manage IO coming in . With the understanding flushes to disk  are restricted during the snapshot backup.  The ideal time to execute a snapshot backups is out of business hrs

Read More

Virtual Device Interface (VDI) and sysadmin

SQL Server - Display restore history for a single database <

SQL Server - Display sql backup history for a single database


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on I/O is frozen on database. No user action is required


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer