[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 815
  • Last Modified:

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-5714-462C-9837-0F21BDB6C2AB}2' WITH SNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024

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::PrepareToFreeze:  failure on backup device '{9DCD6B92-5714-462C-9837-0F21BDB6C2AB}2'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).


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?

0
Vicki_Cheng
Asked:
Vicki_Cheng
  • 4
  • 3
1 Solution
 
Brian BIndependant Technology ProfessionalCommented:
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.
0
 
Vicki_ChengAuthor Commented:
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?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Brian BIndependant Technology ProfessionalCommented:
Other that to say it was never supposed to work in the first place, I can't say for sure. Maybe the backup had been failing all along but you never saw. You can't back up a live MSSQL database with ntbackup. First you have to set up a maintenance job in SQL that backups up the databases to a directory. Then you can back up the directory to tape with ntbackup.
0
 
Vicki_ChengAuthor Commented:
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
0
 
Brian BIndependant Technology ProfessionalCommented:
Thanks for the update. The volume shadow service should stay on, but it only runs when needed.
0
 
Vicki_ChengAuthor Commented:
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
0
 
Brian BIndependant Technology ProfessionalCommented:
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.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now