Thursday, March 07, 2013 7:42 AM
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.
Thursday, March 07, 2013 8:05 AM
you can resolve this check this link for solution
Ramesh Babu Vavilla MCTS,MSBI
Thursday, March 07, 2013 9:28 AMModeratorThat 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.