SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 IO Frozen / IO Thawed
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kappa02
Yak Posting Veteran

58 Posts

Posted - 04/01/2013 :  14:18:02  Show Profile  Reply with Quote
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???

tkizer
Almighty SQL Goddess

USA
36599 Posts

Posted - 04/01/2013 :  15:04:06  Show Profile  Visit tkizer's Homepage  Reply with Quote
I haven't worked on version 2000 in years, but I don't remember seeing those messages in the error log. To confirm that there is or isn't an issue, perform a restore to a test machine or restore with a different name.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

robvolk
Most Valuable Yak

USA
15655 Posts

Posted - 04/01/2013 :  15:10:28  Show Profile  Visit robvolk's Homepage  Reply with Quote
Check here: http://blogs.msdn.com/b/sqlserverfaq/archive/2009/04/28/informational-shedding-light-on-vss-vdi-backups-in-sql-server.aspx

You'll have to check the Arcserv documentation to see if it's VDI/VSS compatible, or contact their support. It sounds like it may have done a VSS snapshot.

Generally speaking I recommend using native SQL Server backups, or a SQL Server specific backup utility like Quest LiteSpeed or Redgate SQL Backup. Most general backup products like Netbackup, Arcserv, and DPM are not VDI aware and may not support the same restore granularity.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000