Prev: Select distinct
Next: how query Active Directory from sql2k server?
From: David on 16 Feb 2005 11:42
Our SQL Server 2000 has had the following 2 messages show up in the SQL
Server Logs in last 2 days.

IO is frozen for snapshot
IO is thawed.

Can anyone give me any information/cause on them? Thanks.

David


From: Anith Sen on 16 Feb 2005 12:09
These are generally initiated by certain 3rd party tools, commonly used for
drive backups. Internally two deprecated DBCC commands, DBCC freeze_io &
DBCC thaw_io are used for shadow copy backups which generates such messages
in the SQL Server Error Log. ( one example is Arcserve backup agent )

These are potentially damaging ( can cause slowdowns or perhaps hang the
server ) and hence it is generally recommended that you talk with your
vendor support regarding this.

See:
http://groups-beta.google.com/group/microsoft.public.sqlserver.server/msg/7290ebefc4976b8b

--
Anith


 | 
Pages: 1
Prev: Select distinct
Next: how query Active Directory from sql2k server?