Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Its All About SQL Server
Browse by Tags · View All
Sql Server 2008 39
SQL Server 2012 39
Sql Server 2005 37
SQL Server Basics 11
TSQL Tips n Tricks 11
Performance Tuning 11
Sql Server Management 10
SQL Server Log 9
SQL Server Errors 9
Scripts 8

Archive · View All
July 2012 12
August 2012 8
September 2012 6
June 2012 6
November 2011 5
October 2011 3
August 2011 3
November 2012 2
October 2012 2
January 2012 2

ConnectSQL

SQL Server Log: I/O is frozen on database DatabaseName

Jul 25 2012 2:46PM by aasim abdullah   


One more daily base SQL Server log message reported from one of our production server was
I/O is frozen on database model. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.
AND
I/O was resumed on database DATABASENAME. No user action is required.

First thing to note is that it’s just a message and not an error and no user action is required. On investigation for said production server, I found that our System Administrators has enabled SQL Server backup through VSS (Volume Shadow Copy Services) and this process actually freeze I/O temporarily to take shadow copy and release it back once process is complete. How it works read here.


Republished from Connect SQL [12 clicks].  Read the original version here [1 clicks].
aasim abdullah
23 · 7% · 2372
2
 
0
Lifesaver
 
1
 
0
Learned
 
0
Incorrect


Submit

Your Comment
Sign Up or Login to post a comment.
"SQL Server Log: I/O is frozen on database DatabaseName" rated 5 out of 5 by 2 readers
SQL Server Log: I/O is frozen on database DatabaseName , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]