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

Question

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

Mr. Kapsicum

SSCertifiable

Points: 6128
More actions
April 24, 2015 at 5:04 am

#303223

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.

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

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

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 1

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.

😎

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 2

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

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 3

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

😎

SELECT @@VERSION

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 4

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: )

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 5

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.

😎

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 6

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

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 7

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

😎

mnadirwk SSC-Addicted Points: 476 More actions · Answer 8

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)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

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?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

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

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 11

have you seen this link: https://support.microsoft.com/en-us/kb/2487231