8

I would like to say that as on daily basis i got the message in my log file.

First The I/O is frozen on Database (DatabaseName) message appears in log. The message is like

I/O is frozen on Database (DatabaseName).No User action is required. However, if I/O is not resumed promptly, you could cancel the backup.

And then I/O was resumed on Database(DatabaseName) message appears like

I/O was resumed on Database (DatabaseName). No user action is required.

And finally the backup has done of Database with successfully with like this message

No User Action is Required

It is My production Audit database and having the software Environment is like:

Windows Server 2012 R2
SQL Server 2012
VMware Tools

My production Database "Recovery Model" is "Full" recovery model. And from which login ID in SQL Server, the Maintenance Plan Backup was setup.That has "sysadmin" privileges for all databases.

The Backup has setup through "Maintenance Plan" Backup at specific time schedule like 4.00 P.M. at every day. And Always Backup went through successfully at their schedule interval.

Why such kind of log message generate in at schedule backup time. Is this kind of message will impact to my Production Database performance. Will be any issues in (Backup/Restore) data consistency in my production database.

Any suggestion will be appreciated.

  • 3
    This is actually not a issue but how VSS backups works you must read blogs.msdn article blogs.msdn.com/b/sqlserverfaq/archive/2009/04/28/… – Shanky Jul 30 '15 at 11:07
  • @Shanky, you are right i have check out on "Server Manager-> Local Server" on same time VSS Application raised Error. – Md Haidar Ali Khan Jul 30 '15 at 11:17
  • @Haidar Its OK I guess KASQLDBA has already given answer to your question. There is no point in posting same answer to the question. – Shanky Jul 30 '15 at 13:06
10

I believe its just a message and not an error unless and until the task is getting impacted when this message is logged in the error log:

We also encountered the same for one of our production server, where windows admin team enabled the SQL Server backup through VSS (Volume Shadow Copy Services). And when this process runs it freezes I/O temporarily to take shadow copy and release it back once process is complete.

Major cause being "I/O on the database is frozen in order for any backup service using Virtual Device Interface (VDI) and commiting a sql snapshot backup." as mentioned here

For a better understanding how this process works please read How It Works: SQL Server - VDI (VSS) Backup Resources2

Therefore i believe you should start looking for process like Volume Shadow Copy (VSS) OR Data Protection Manager (DPM) running on the server and discuss with system admin team for what is enabled and to ensure nothing is impacted.

  • 1
    you are right i have gone through Local Server and check out the VSS event log and find out as on same time the VSS raised a error. – Md Haidar Ali Khan Jul 30 '15 at 11:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.