Backup job fails to complete and SQLServer hangs

Hi

I have a Widnows SBS 2003 server running SQL. Every night I run two backups
- the first backups up everything but the SystemsState, the second backs up
the SystemState alone.

Every second night or so the first NTBackup fails to finish (the process is
still running in the morning), the second backup attempts to start but fails
with the following log:

Volume shadow copy creation: Attempt 1.
Timeout before function completed
Error returned while creating the volume shadow copy:0xffffffff.
Error returned while creating the volume shadow copy:ffffffff
Aborting Backup.
----------------------
The operation did not successfully complete.

The problem is that SqlServer stops responding at some stage during or
before the backup and can only be rectified by rebooting the server.


The SqlServer error log has the following lines at the end:

2008-02-07 00:30:23.43 spid53 Database master: IO is frozen for snapshot
2008-02-07 00:30:23.52 spid54 Database model: IO is frozen for snapshot
2008-02-07 00:30:23.61 spid55 Database msdb: IO is frozen for snapshot
2008-02-07 00:30:23.69 spid56 Database pubs: IO is frozen for snapshot
2008-02-07 00:30:23.79 spid59 Database Northwind: IO is frozen for snapshot
2008-02-07 00:30:23.88 spid58 Database WRAP_Temp: IO is frozen for snapshot
2008-02-07 00:30:23.96 spid61 Database wrap_devel: IO is frozen for
snapshot
2008-02-07 00:30:24.04 spid57 Database ClientTracker: IO is frozen for
snapshot
2008-02-07 00:30:24.21 spid60 Database wrap: IO is frozen for snapshot
2008-02-07 00:30:24.38 spid62 Database Archive: IO is frozen for snapshot
2008-02-07 08:11:15.50 server SQL Server terminating because of system
shutdown.
2008-02-07 08:11:15.50 server LogEvent: Failed to report the current
event. Operating system error = 31(A device attached to the system is not
functioning.).

The stuff at 08:11 am is me rebooting the server. So to me it seems that the
backup job is locking the files but then not releasing them? Does that sounds
right?

Any help would be great.

.

Relevant Pages

  • RE: SBS Back up Failure
    ... attached the log and report from yesterday's backup also. ... One or more components of Small Business Server Backup failed. ... recommended that you review errors in the Event log related to the service. ... Notifications task in the Server Management Monitoring and Reporting taskpad. ...
    (microsoft.public.windows.server.sbs)
  • Re: MSKB 891957, VSS Update for Windows Server 2003
    ... Well, it turns out the RDP connection dropping issue won't go away, ... level to the server in the office may have an affect on the issue. ... I just remembered I also re-installed RDP Client V6 last night as ... I left the server with user Backup logged in when I left the ...
    (microsoft.public.windows.server.general)
  • Re: MSKB 891957, VSS Update for Windows Server 2003
    ... I left the connection sit idle and checked back in an hour. ... server and browsed around for a few minutes. ... it would seem that there is still some issue with the V6 RDP ... I left the server with user Backup logged in when I left the ...
    (microsoft.public.windows.server.general)
  • Re: SCO 5.0.7 MP5 network hung up
    ... The last time I had a problem with streams on 5.0.7 it was caused by ... Is Samba in the mix? ... own directory, such as '/var/fetch', so it can be left out of backup ... "floating" IP address and be served by the backup server. ...
    (comp.unix.sco.misc)
  • RE: Server Management Backup Page Not Found
    ... reinstall backup and monitoring components. ... Perform a full backup of the SBS server. ...
    (microsoft.public.windows.server.sbs)
Loading