SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database IO is frozen for snapshot / IO is thawed


Database IO is frozen for snapshot / IO is thawed

Author
Message
kd11
kd11
Old Hand
Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)

Group: General Forum Members
Points: 340 Visits: 1492
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???
Eddie Wuerch
Eddie Wuerch
SSC Eights!
SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)

Group: General Forum Members
Points: 922 Visits: 2200
That message is 2 1/2 years old. Were you taking SAN snapshots then? Is this happening currently?

Eddie Wuerch
MCM: SQL
kd11
kd11
Old Hand
Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)

Group: General Forum Members
Points: 340 Visits: 1492
To my knowledge I don't belive we were, but if we were I'm assuming we shouldn't.
Markus
Markus
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3039 Visits: 3775
That is your back end SAN snapshot. We have it here as well. Talk with your storage Admin



rollercoaster43
rollercoaster43
SSC-Enthusiastic
SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)

Group: General Forum Members
Points: 129 Visits: 435
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.
Mike Hinds
Mike Hinds
SSC Eights!
SSC Eights! (998 reputation)SSC Eights! (998 reputation)SSC Eights! (998 reputation)SSC Eights! (998 reputation)SSC Eights! (998 reputation)SSC Eights! (998 reputation)SSC Eights! (998 reputation)SSC Eights! (998 reputation)

Group: General Forum Members
Points: 998 Visits: 1109
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search