Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
I/O frozen and resume log in SQL logs

Unanswered I/O frozen and resume log in SQL logs

  • Thursday, March 07, 2013 7:42 AM
     
     
    Sign In to Vote
    0

    Hi All

    We are using LiveVault server for continuous backup of our production SQL server. But every time job start it logged an event in SQL server logs that says I/O is freozen on database you may cancel backup and at the same time othe event is logged says that I/O is resume on database no user action required.

    I search some blogs and find that this is a default behavior but I need to prove this to my management.Is there something from Microsoft on web to get reference or this is serious issue in my server.

    Please suggest.

    Thanks

     

All Replies

  • Thursday, March 07, 2013 8:05 AM
     
     
    Sign In to Vote
    0

    you can resolve this check this link for solution

    http://sqlservertimes2.com/?p=816

    Ramesh Babu Vavilla MCTS,MSBI

     
  • Thursday, March 07, 2013 9:28 AM
    Moderator
     
     
    Sign In to Vote
    0
    That was a strange article. It suggests that this is a "problem" that need to be resolved... The fact is that it is up to the backup software how it want to do backup of SQL Server. Either use some snapshot technology, meaning that you will see this messages and that is perfectly normal. Or, use the traditional backup types (VDI), where SQL Server itself produces the backup data. Suggestion that snapshot is something that need to be corrected is a strange viewpoint.

    Tibor Karaszi, SQL Server MVP | web | blog