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.