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

sql 2005

joesjoes Posts: 11
edited May 9, 2007 8:26AM in SQL Backup Previous Versions
i'm having an issue with large backups.. i am using sql backup 4.2.0.425, win2k3,sql2005 sp1.

I have tried to put the maxtranfer statements and they don't seem to work.

Here is the error i'm getting, please help .

Date 5/6/2007 9:00:00 AM
Log Job History (Red Gate DB Backup Job - Tradiudit)

Step ID 1
Server CGSQLARCHI003
Job Name Red Gate DB Backup Job - Tradindit
Step Name Step 1
Duration 02:38:18
Sql Severity 16
Sql Message ID 50000
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: SCOTTAPP\sqlarchi003. SQL Backup job failed with exitcode: 1050 SQL error code: 3202 [SQLSTATE 42000] (Error 50000). The step failed.
joe s

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Could you pls provide the SQL Backup log for the backup that failed? The default folder for the logs is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Below is the error log, i see it says there isn't enough space.. which there is plenty of free space.. so I'm not sure why it states that.. it hasn't seemed to work correctly since being moved to sql 2005.

    thanks for your help.

    joe



    SQL Backup log file
    5/6/2007 10:10:00 AM: Backing up Tradindit (differential database) to:
    \\cgsqlba001\prodback\CQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_01.sqb
    \\cgsqlba001\prodback\CQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_02.sqb

    5/6/2007 10:10:00 AM: BACKUP DATABASE [Tradindit] TO DISK = '\\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_01.sqb', DISK = '\\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_02.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', DIFFERENTIAL, ERASEFILES_ATSTART = 2, COMPRESSION = 2, THREADS = 2

    5/6/2007 10:10:42 AM: Deleting old backup file: \\cgsqlbak001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070503_101001.sqb
    5/6/2007 10:12:02 AM: Deleting old backup file: \\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070503_101001_02.sqb
    5/6/2007 10:12:20 AM: VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had elapsed.)
    5/6/2007 11:38:15 AM: SQL error 3013: BACKUP DATABASE is terminating abnormally.
    5/6/2007 11:38:15 AM: SQL error 3201: Cannot open backup device 'SQLBACKUP_0087C2BA-0653-4F73-B7D9-B2F4EDF37B40'. Operating system error 0x80070002(The system cannot find the file specified.).
    5/6/2007 11:38:15 AM:
    5/6/2007 11:38:16 AM: Memory profile
    5/6/2007 11:38:16 AM: Type Maximum Minimum Average Blk count Total
    5/6/2007 11:38:16 AM:





    5/6/2007 11:38:16 AM: Commit 792133632 4096 1736286 1031 1790111744
    5/6/2007 11:38:16 AM: Reserve 4128768 8192 235049 161 37842944
    5/6/2007 11:38:16 AM: Free 160628736 4096 1890316 169 319463424
    5/6/2007 11:38:16 AM: Private 792133632 4096 2523230 693 1748598784
    5/6/2007 11:38:16 AM: Mapped 1060864 4096 107676 59 6352896
    5/6/2007 11:38:16 AM: Image 24707072 4096 165915 440 73003008
    5/6/2007 11:38:16 AM:
    5/6/2007 11:38:16 AM:
    5/6/2007 11:38:16 AM: Warning 300: Backup failed. Retry attempt: 1
    5/6/2007 11:38:18 AM: BACKUP DATABASE [TradingAudit] TO DISK = '\\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_01.sqb', DISK = '\\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_02.sqb' WITH NAME = 'Database (Tradindit), 5/6/2007 10:10:00 AM', DESCRIPTION = 'Backup on 5/6/2007 10:10:00 AM Server: CGSQLARCHI003 Database: Tradindit', DIFFERENTIAL, INIT, ERASEFILES_ATSTART = 2, COMPRESSION = 2, THREADS = 2

    5/6/2007 11:38:18 AM: Thread 0 error:
    Error 605: Error creating backup file(s). No files could be created.
    Thread 0 warning:
    Warning 200: Error creating backup file: \\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_01.sqb.
    Warning: System error code: (Not enough server storage is available to process this command)
    5/6/2007 11:38:18 AM: Thread 1 error:
    Error 605: Error creating backup file(s). No files could be created.
    Thread 1 warning:
    Warning 200: Error creating backup file: \\cgsqlbak001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_02.sqb.
    Warning: System error code: (Not enough server storage is available to process this command)

    5/6/2007 11:38:19 AM: Server: Msg 3013
    BACKUP DATABASE is terminating abnormally.
    5/6/2007 11:38:19 AM: Server: Msg 3202
    Write on "SQLBACKUP_70F42DF1-F60C-44D5-BA86-CB5E6159923501" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)
    5/6/2007 11:38:19 AM: Server: Msg 3271
    A nonrecoverable I/O error occurred on file "SQLBACKUP_70F42DF1-F60C-44D5-BA86-CB5E61599235:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
    5/6/2007 11:38:19 AM: Failed to close vdi.
    joe s
Sign In or Register to comment.