Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 4, 2014 12:18 PM
Points: 141, Visits: 1,117
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: Tuesday, July 29, 2014 1:18 PM
Points: 442, Visits: 1,124
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 4, 2014 12:18 PM
Points: 141, Visits: 1,117
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 1,269, Visits: 2,781
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: Yesterday @ 12:45 PM
Points: 62, Visits: 408
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


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 11:32 AM
Points: 614, Visits: 864
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.


Regards, Mike
Post #1438297
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse