January 27, 2015 at 8:05 pm
Hi Friend,
The DB backup fails continuously even with manual backup or scheduled maintenance plan. The error in the Job history is not sufficient to identify the failure reason. kindly help.
The error as below.
Microsoft(R) Server Maintenance Utility (Unicode) Version 10.50.1600
Report was generated on "ABCSERVER".
Maintenance Plan: MaintenancePlan
Duration: 00:05:04
Status: Warning: One or more tasks failed.
Details:
Back Up Database Task (ABCSERVER)
Backup Database on DB_Backup
Databases: XYZ Live
Type: Full
Append existing
Task start: 2015-01-27T12:42:28.
Task end: 2015-01-27T12:47:32.
Failed:(-1073548784) Executing the query "BACKUP DATABASE [XYZ Live] TO DISK = N'E:\\La..." failed with the following error: "The backup or restore was aborted.
BACKUP DATABASE is terminating abnormally.
A severe error occurred on the current command. The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:BACKUP DATABASE [XYZ Live] TO DISK = N''E:\Latest_ERP_Backup_2015\XYZ Live_backup_2015_01_27_124228_9326807.bak'' WITH RETAINDAYS = 14, NOFORMAT, NOINIT, NAME = N''XYZ Live_backup_2015_01_27_124228_9326807'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''XYZ Live'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''XYZ Live'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''XYZ Live'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''E:\Latest_ERP_Backup_2015\XYZ Live_backup_2015_01_27_124228_9326807.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
January 27, 2015 at 8:30 pm
Pradeep can you check if there is enough free space on the disk on which you are taking backup.
Also, is there any offline database on the server , and your maintenance plan is trying to take backup of that database.
January 27, 2015 at 10:35 pm
Thanks Bhushan for your reply.
Initially I thought same and there was really storage issue with only 50 GB in drive and the Datafile was 20GB, and Log file was 190 GB. Then i removed the unwanted stuff from the drive and made 220 GB space available. Then I took a manual backup and it successfully done for 2-3 more manual backup. Then I try to run through maintenance plan it failed again. Since then I am unable to do backup either manually or through maintenance plan.
Today I try to run backup using SQL command as
BACKUP DATABASE [XYZ Live] TO DISK = N'W:\Latest_ERP_Bkp_2015\Full_Backup\XYZ Live_backup_2015_01_28_081353_6074620.bak' WITH RETAINDAYS = 10, NOFORMAT, NOINIT, NAME = N'XYZ Live_backup_2015_01_28_081353_6074620', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
then this resulted to below error
Msg 3204, Level 16, State 1, Line 1
The backup or restore was aborted.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
10 percent processed.
Msg 3204, Level 16, State 1, Line 1
The backup or restore was aborted.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Then I did a check DBCC CHECKDB
DBCC CHECKDB ([Creative Live]) WITH NO_INFOMSGS, ALL_ERRORMSGS
it throws error as
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Now I am unable to track what is the error.
Please help
Regrads
Pradeep
January 27, 2015 at 10:52 pm
There is no offline databases and in maintenance plan i selected only one specific DB.
Regards
Pradeep
January 30, 2015 at 9:33 pm
Can you take a Differential ? If so, at least you will have some protection with the Full that did work, plus a new diff. If it fails, maybe it will shed light on the problem.
February 8, 2015 at 8:37 pm
Check your your maintenance plan
March 7, 2015 at 4:23 am
Thank you friends for your support.
Sorry for updating this very later. The issue is resolved.
The issue was we set a scheduler to kill the idle user sessions, which is killing all session as there was not filter applied to it. After finding out i changed the code to only kill idle user session then its solved.
Thanks you.
Regards
Pradeep
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply