Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

The log shows IO DBName is Frozen follow by thaw but yet my database schedule backup task which normally been running isn't since the network team are doing backs (not database backups, according to them) on the database server, using ArcServ 16.5. They run their backup utility around 11:00pm or later And my maintenance backup runs at 2:00am. This is in a 2000 SP4 environment. I would like to gather much evidence to show them that their utility is cause my schedule backs not to run.

share|improve this question
    
How can you tell that your database is "frozen" ? What kind of errors are you having (what do the logs tell you) ? Are you sure their backup utility is taking more then 3 hours to backup the server? –  KookieMonster Apr 2 '13 at 9:55
1  
Can you please post the exact errors from the errorlog? –  Patrick Keisler Apr 2 '13 at 14:15
add comment

1 Answer

You are getting this because something is having the storage array take SAN level backups. If you aren't on a SAN, then it could be something else on the server taking a snapshot of the disks for some backup purpose. If they are using ArcServ to take disk based backups (which I wouldn't consider an acceptable backup solution) that's probably what's causing the IO to be frozen.

Can you post more information about what is being backed up with ArcServ and via what process?

(Insert standard message about SQL 2000 falling out of support this month here.)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.