What are the challenges you face when working across database platforms? Take the survey
Options

Old Script New Tricks

SinclairSpeccySinclairSpeccy Posts: 7
edited February 9, 2006 10:46AM in SQL Backup Previous Versions
I have 2 backup scripts:

master..sqlbackup N'-SQL "BACKUP DATABASE [db_Import]
TO DISK = ''E:\<AUTO>'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', VERIFY, ERASEFILES = 3, COMPRESSION = 3"'

master..sqlbackup N'-SQL "BACKUP DATABASE [db_Import]
TO DISK = ''E:\Backups\ITSVPKSR02\<AUTO>'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', VERIFY, ERASEFILES = 3, COMPRESSION = 3"'


These are being run from SQL Query Analyser, the first one works, the second one doesn’t. The second script has been running for quite some time (SQL Server Agent Scheduled) but since upgrading to Version 4 I get the following errors:


Backing up db_Import (full database) to:
E:\Backups\ITSVPKSR02\FULL_ITSVPKSR02_db_Import_20060209 121725.sqb

Failed to create backup folder : E:\Backups\ITSVPKSR02SQL Backup exit code: 500

And

exitcode 500
sqlerrorcode 0
filename01 E:\Backups\ITSVPKSR02\FULL_ITSVPKSR02_db_Import_20060209 121725.sqb

I am also getting the following in the event log:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 09/02/2006
Time: 11:36:40
User: N/A
Computer: ITSVPKSR02
Description:
18210 :
BackupVirtualDeviceSet::AllocateBuffer: failure on backup device 'SQLBACKUP_D77F982C-058E-417C-9C9E-26B82FA4595D'. Operating system error 995(error not found).


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: 0b 00 00 00 49 00 54 00 ....I.T.
0010: 53 00 56 00 50 00 4b 00 S.V.P.K.
0018: 53 00 52 00 30 00 32 00 S.R.0.2.
0020: 00 00 00 00 00 00 ......


AND


Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 09/02/2006
Time: 11:36:40
User: N/A
Computer: ITSVPKSR02
Description:
3041 :
BACKUP failed to complete the command sp_executesql;1


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: 0b 00 00 00 49 00 54 00 ....I.T.
0010: 53 00 56 00 50 00 4b 00 S.V.P.K.
0018: 53 00 52 00 30 00 32 00 S.R.0.2.
0020: 00 00 00 00 00 00 ......


This is happening across all databases and affects logs and full backups.
Can someone please help to resolve this?

Comments

Sign In or Register to comment.