Vicki_Cheng
asked on
Server Backup error
i have got a backup problem.
i have got a server need to be backup fully everyday. and a few days ago, it stopped working. i went to check the event log and i have got this 3 event ID appearing repeatedly.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 04/01/2010
Time: 11:26:49 AM
User: NT AUTHORITY\SYSTEM
Computer: SOAU
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [model] TO VIRTUAL_DEVICE='{9DCD6B92-
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: e1 0b 00 00 10 00 00 00 ?......
0008: 05 00 00 00 53 00 4f 00 ....S.O.
0010: 41 00 55 00 00 00 00 00 A.U.....
0018: 00 00 ..
--------------------------
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 04/01/2010
Time: 11:26:49 AM
User: NT AUTHORITY\SYSTEM
Computer: SOAU
Description:
18210 :
BackupVirtualDeviceFile::P
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 22 47 00 00 10 00 00 00 "G......
0008: 05 00 00 00 53 00 4f 00 ....S.O.
0010: 41 00 55 00 00 00 06 00 A.U.....
0018: 00 00 6d 00 6f 00 64 00 ..m.o.d.
0020: 65 00 6c 00 00 00 e.l...
--------------------------
Event Type: Error
Event Source: VSS
Event Category: None
Event ID: 6013
Date: 04/01/2010
Time: 11:26:50 AM
User: N/A
Computer: SOAU
Description:
Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error message: BACKUP DATABASE is terminating abnormally.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 2d 20 43 6f 64 65 3a 20 - Code:
0008: 53 51 4c 43 4f 4e 4e 43 SQLCONNC
0010: 30 30 30 30 30 36 33 39 00000639
0018: 2d 20 43 61 6c 6c 3a 20 - Call:
0020: 53 51 4c 43 4f 4e 4e 43 SQLCONNC
0028: 30 30 30 30 30 36 31 34 00000614
0030: 2d 20 50 49 44 3a 20 20 - PID:
0038: 30 30 30 30 34 31 34 34 00004144
0040: 2d 20 54 49 44 3a 20 20 - TID:
0048: 30 30 30 30 35 37 37 36 00005776
0050: 2d 20 43 4d 44 3a 20 20 - CMD:
0058: 43 3a 5c 57 49 4e 44 4f C:\WINDO
0060: 57 53 5c 53 79 73 74 65 WS\Syste
0068: 6d 33 32 5c 76 73 73 76 m32\vssv
0070: 63 2e 65 78 65 20 20 20 c.exe
0078: 2d 20 55 73 65 72 3a 20 - User:
0080: 4e 54 20 41 55 54 48 4f NT AUTHO
0088: 52 49 54 59 5c 53 59 53 RITY\SYS
0090: 54 45 4d 20 20 20 20 20 TEM
0098: 2d 20 53 69 64 3a 20 20 - Sid:
00a0: 53 2d 31 2d 35 2d 31 38 S-1-5-18
i tried to restart the volume shadow copy service and re-run the ntbackup schedule task however, the service would be stopped itself again and the backup file is only 2KB of size.
can someone help please?
i have got a server need to be backup fully everyday. and a few days ago, it stopped working. i went to check the event log and i have got this 3 event ID appearing repeatedly.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 04/01/2010
Time: 11:26:49 AM
User: NT AUTHORITY\SYSTEM
Computer: SOAU
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [model] TO VIRTUAL_DEVICE='{9DCD6B92-
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: e1 0b 00 00 10 00 00 00 ?......
0008: 05 00 00 00 53 00 4f 00 ....S.O.
0010: 41 00 55 00 00 00 00 00 A.U.....
0018: 00 00 ..
--------------------------
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 04/01/2010
Time: 11:26:49 AM
User: NT AUTHORITY\SYSTEM
Computer: SOAU
Description:
18210 :
BackupVirtualDeviceFile::P
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 22 47 00 00 10 00 00 00 "G......
0008: 05 00 00 00 53 00 4f 00 ....S.O.
0010: 41 00 55 00 00 00 06 00 A.U.....
0018: 00 00 6d 00 6f 00 64 00 ..m.o.d.
0020: 65 00 6c 00 00 00 e.l...
--------------------------
Event Type: Error
Event Source: VSS
Event Category: None
Event ID: 6013
Date: 04/01/2010
Time: 11:26:50 AM
User: N/A
Computer: SOAU
Description:
Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error message: BACKUP DATABASE is terminating abnormally.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 2d 20 43 6f 64 65 3a 20 - Code:
0008: 53 51 4c 43 4f 4e 4e 43 SQLCONNC
0010: 30 30 30 30 30 36 33 39 00000639
0018: 2d 20 43 61 6c 6c 3a 20 - Call:
0020: 53 51 4c 43 4f 4e 4e 43 SQLCONNC
0028: 30 30 30 30 30 36 31 34 00000614
0030: 2d 20 50 49 44 3a 20 20 - PID:
0038: 30 30 30 30 34 31 34 34 00004144
0040: 2d 20 54 49 44 3a 20 20 - TID:
0048: 30 30 30 30 35 37 37 36 00005776
0050: 2d 20 43 4d 44 3a 20 20 - CMD:
0058: 43 3a 5c 57 49 4e 44 4f C:\WINDO
0060: 57 53 5c 53 79 73 74 65 WS\Syste
0068: 6d 33 32 5c 76 73 73 76 m32\vssv
0070: 63 2e 65 78 65 20 20 20 c.exe
0078: 2d 20 55 73 65 72 3a 20 - User:
0080: 4e 54 20 41 55 54 48 4f NT AUTHO
0088: 52 49 54 59 5c 53 59 53 RITY\SYS
0090: 54 45 4d 20 20 20 20 20 TEM
0098: 2d 20 53 69 64 3a 20 20 - Sid:
00a0: 53 2d 31 2d 35 2d 31 38 S-1-5-18
i tried to restart the volume shadow copy service and re-run the ntbackup schedule task however, the service would be stopped itself again and the backup file is only 2KB of size.
can someone help please?
Brian B
I assume you are using Windows backup? Are you trying to backup a SQL database while it is running? You can't do that. You have to back it up within SQL.
ASKER
reply to "TBone2K:
I assume you are using Windows backup? Are you trying to backup a SQL database while it is running? You can't do that. You have to back it up within SQL."
i am assuming yes. but the weird thing is it was always working until a few days ago. i havent change anything. and in the first few times, after i restarted the volume shadow copy service, the system would start backing up. but now it will not. is there any reason?
I assume you are using Windows backup? Are you trying to backup a SQL database while it is running? You can't do that. You have to back it up within SQL."
i am assuming yes. but the weird thing is it was always working until a few days ago. i havent change anything. and in the first few times, after i restarted the volume shadow copy service, the system would start backing up. but now it will not. is there any reason?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i think you are right. i have change the backup directory and will monitor it from now on. by the way, is the volume shadow copy service supposed to be running all the time or only will be invoked upon any application request?
thanks
thanks
Thanks for the update. The volume shadow service should stay on, but it only runs when needed.
ASKER
reply to "TBone2K:
Thanks for the update. The volume shadow service should stay on, but it only runs when needed."
actually i found that the volume shadow copy server will stop itself on this server and the backup for last night fail again. do you know what has caused this service to stop? i have already configured it to not to back up DB. thanks
Thanks for the update. The volume shadow service should stay on, but it only runs when needed."
actually i found that the volume shadow copy server will stop itself on this server and the backup for last night fail again. do you know what has caused this service to stop? i have already configured it to not to back up DB. thanks
If there is an error associated with this stoppage, searching the eventid may be helpful. However, this is probably a separate problem and should be posted as a new question to get the most attention from the appropriate experts.