Msg 3013, Level 16, State 1, Line 2 BACKUP DATABASE is terminating abnormally.

  • BACKUP DATABASE [Staging] TO DISK = N'\\NetworkStorageLocation\ProjectA\Test_backup_2015_04_24_105955_2107357.bak' WITH NOFORMAT, NOINIT, NAME = N'Test_backup_2015_04_24_105955_2107357', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10

    GO

    Error Message that i get

    Msg 3013, Level 16, State 1, Line 2

    BACKUP DATABASE is terminating abnormally.

    Two days back, This Backup script was working fine. I checked with IT Team, the Domain User has write access on Network storage folder. Not sure what is happening, Checked in various SQL Forums, but concrete help as such.

    Please let me know , if more information is required.

  • Mr. Kapsicum (4/24/2015)


    BACKUP DATABASE [Staging] TO DISK = N'\\NetworkStorageLocation\ProjectA\Test_backup_2015_04_24_105955_2107357.bak' WITH NOFORMAT, NOINIT, NAME = N'Test_backup_2015_04_24_105955_2107357', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10

    GO

    Error Message that i get

    Msg 3013, Level 16, State 1, Line 2

    BACKUP DATABASE is terminating abnormally.

    Two days back, This Backup script was working fine. I checked with IT Team, the Domain User has write access on Network storage folder. Not sure what is happening, Checked in various SQL Forums, but concrete help as such.

    Please let me know , if more information is required.

    First thought is that the drive has insufficient free space for the operation, bear in mind that compression doesn't fully apply until after the backup has been written, the final stage normally reduces the file size by 50%. This means that the free space must be at least twice the backup file size.

    😎

  • Database Size is 2gb. and Network Storage has around 300 GB free space. 🙁

    Moreover, i tried to perform Backup on Local machine itself.

    BACKUP DATABASE Test TO DISK = N'E:\Backup\Test_backup_2015_04_24_105955_2107357.bak'

    Same Error message i got

  • Quick question, what is the SQL Server Edition and Version?

    😎

    SELECT @@VERSION

  • Sorry for the delayed response

    Version is : Microsoft SQL Server 2014 - 12.0.2000.8 (X64)

    Feb 20 2014 20:04:26

    Copyright (c) Microsoft Corporation

    Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 <X64> (Build 9200: )

  • Mr. Kapsicum (4/24/2015)


    Sorry for the delayed response

    Version is : Microsoft SQL Server 2014 - 12.0.2000.8 (X64)

    Feb 20 2014 20:04:26

    Copyright (c) Microsoft Corporation

    Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 <X64> (Build 9200: )

    No worries,

    you have a Vanilla RTM install, suggest you start by patching to CU5 at least and see if the problem persists. Cannot recall this particular problem on the list of fixes but I do recall at least 4 backup related problems being fixed.

    😎

  • Didn't understand what exactly you mean, Are you suggesting for Build Update.?

    Like. https://technet.microsoft.com/en-us/sqlserver/ff803383.aspx

    Thanks and Regards

  • Mr. Kapsicum (4/24/2015)


    Didn't understand what exactly you mean, Are you suggesting for Build Update.?

    Like. https://technet.microsoft.com/en-us/sqlserver/ff803383.aspx

    Thanks and Regards

    Should have been clearer, the update is the Cumulative update package 5 for SQL Server 2014

    😎

  • add MAXTRANSFERSIZE= 1048576

    e.g

    DBCC TRACEON (3605, -1)

    DBCC TRACEON (3213, -1)

    BACKUP DATABASE [xyz_hist ] TO

    DISK = N'\\qnap-wb\SQLBACKUP\MCWBEDW\xyz0.bak',

    DISK = N'\\qnap-wb\SQLBACKUP\MCWBEDW\xyz1.bak',

    DISK = N'\\qnap-wb\SQLBACKUP\MCWBEDW\xyz2.bak'

    WITH

    NOFORMAT, INIT, NAME = N'xyz_hi-Full Database Backup',

    SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 5

    ,BUFFERCOUNT = 2200

    ,BLOCKSIZE = 65536

    ,MAXTRANSFERSIZE=1048576

    ,MAXTRANSFERSIZE=1310720

    DBCC TRACEOFF(3605, -1)

    DBCC TRACEOFF(3213, -1)

  • mnadirwk (10/6/2016)


    add MAXTRANSFERSIZE= 1048576

    e.g

    DBCC TRACEON (3605, -1)

    DBCC TRACEON (3213, -1)

    BACKUP DATABASE [xyz_hist ] TO

    DISK = N'\\qnap-wb\SQLBACKUP\MCWBEDW\xyz0.bak',

    DISK = N'\\qnap-wb\SQLBACKUP\MCWBEDW\xyz1.bak',

    DISK = N'\\qnap-wb\SQLBACKUP\MCWBEDW\xyz2.bak'

    WITH

    NOFORMAT, INIT, NAME = N'xyz_hi-Full Database Backup',

    SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 5

    ,BUFFERCOUNT = 2200

    ,BLOCKSIZE = 65536

    ,MAXTRANSFERSIZE=1048576

    ,MAXTRANSFERSIZE=1310720

    DBCC TRACEOFF(3605, -1)

    DBCC TRACEOFF(3213, -1)

    Over one year old thread and why are you suggesting to strip the backup?

  • mnadirwk (10/6/2016)


    add MAXTRANSFERSIZE= 1048576

    Why?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • have you seen this link: https://support.microsoft.com/en-us/kb/2487231

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply