Posted on: 10/23/2013 10:53:37 AM | Views : 353

Hello All,
I am using SQL Server 2012 Express with Microsoft SQL Server Management Studio and currently have 2 databases.  I originally setup a backup for the first database but do not recall how.  We recently had some issues with our server which caused catastrophic data loss. Now there are two issues. #1 Logs show: 2013-10-21 02:56:16.96 spid52      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. 2013-10-21 02:56:16.98 spid56      I/O is frozen on database msdb. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup. 2013-10-21 02:56:16.98 spid57      I/O is frozen on database database2. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup. 2013-10-21 02:56:16.99 spid60      I/O is frozen on database ...

Go to the complete details ...