Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raagi2000
Starting Member
6 Posts |
 Posted - 2005-11-28 : 13:18:07
|
| We are running SQL 2000 SP3A on win 2000 ent server sp1. When i check the error log , the error keeps logging all the time with the message1.Database casearchive: IO is thawed - reoccuring quite often2.Database TIAMaT: IO is frozen for snapshot - reoccuring quite oftenwhen it happens database slows down...Guys any idea why is it happening ? thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-28 : 13:49:17
|
| Those do not look like SQL Server errors. Could you post the entire messages and not just the partial?Tara Kizeraka tduggan |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2005-11-29 : 12:02:12
|
| You also see these messages when you are using SAN hardware and OEM software to do split-mirror backups for SQL Server. It will put the databases into a "frozen" state (no writes), split a BCV or make a volume of pointer copies of the database files, then "thaw" the database. You can then mount the BCV or pointer copy volume to a different server and back it up. Are your storage admins 'testing' some new software?Jon-Like a kidney stone, this too shall pass.http://www.sqljunkies.com/weblog/outerjoin |
|
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-11-29 : 16:17:08
|
quote:
Originally posted by bakerjon
It will put the databases into a "frozen" state (no writes)
Hehehe. I can imagine it's pretty slow if the db is locked/frozen and he is trying to write to it.  Daniel, MCP, A+SQL Server DBAwww.dallasteam.com |
|
|
|
|
|
|
Database slowness