Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database IO is frozen for snapshot / IO is thawed Expand / Collapse
Author
Message
Posted Monday, April 1, 2013 12:14 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 19, 2016 6:46 AM
Points: 206, Visits: 1,438
I notice in my error log there are messages which says the Databasename IO is frozen for snapshot then follow by IO is thawed, it also say that the "Database backed up: Database: databasename(time): 2010/09/12(07:51:45), pages dumped: 1, first LSN. But really it appears that it didn't back anything up. This is on my SQL 2000 box (ver 8.00.2039) we have upgraded our backup utility ArcServ from version 16 to 16.5. could the problem be with our backup utility and, is this a know issue And how to fix it???
Post #1437560
Posted Monday, April 1, 2013 12:24 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 9:01 PM
Points: 483, Visits: 1,705
That message is 2 1/2 years old. Were you taking SAN snapshots then? Is this happening currently?

Eddie Wuerch
MCM: SQL
Post #1437564
Posted Monday, April 1, 2013 1:09 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 19, 2016 6:46 AM
Points: 206, Visits: 1,438
To my knowledge I don't belive we were, but if we were I'm assuming we shouldn't.
Post #1437584
Posted Tuesday, April 2, 2013 5:49 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, May 23, 2016 6:22 AM
Points: 1,498, Visits: 3,517
That is your back end SAN snapshot. We have it here as well. Talk with your storage Admin


Post #1437843
Posted Wednesday, April 3, 2013 4:35 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, January 4, 2016 10:41 PM
Points: 65, Visits: 434
Is it a vM machine? usually Its the VMware backups or Net backups that backs up our Disks generates these messages since it takes a full backup of everythng on the disk. You will also be able to view these Backups in the msdb database history.

You need to note down the timestamp and check with your Storage or System Admins on the programs running during that period.

Post #1438249
Posted Wednesday, April 3, 2013 6:40 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, May 24, 2016 11:55 AM
Points: 740, Visits: 1,010
This "frozen and thawed" backup issue caused me many headaches over the years. Both ArcServe and Symantec Backup Exec were the culprits, on different machines. It effectively broke the backup chain (Full, Differential, Log), which I discovered when I attempted to restore to point-in-time, and was only able to recover to Sunday night.

Finally I got the attention of our system engineers, who were able to exempt my data drives from their backup, and they now backup only my SQL Backup drive, and not my SQL Data and SQL Log drives.


Mike Hinds
Senior Database Administrator
1st Source Bank
MCP, MCTS
Post #1438297
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse