SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup failed


Backup failed

Author
Message
Jitendra Padhiyar
Jitendra Padhiyar
Mr or Mrs. 500
Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)

Group: General Forum Members
Points: 506 Visits: 674
Hello Masters,

My daily differential backup job failed for user databases. all the user database are in simple recovery model. Below is the error log, any clarification are welcome:

message
Executed as user: FRAHTNIMBUS\SYSTEM. ...parameters not set correctly, or connection not established correctly.
End Error Error: 2012-08-20 12:00:15.24 Code: 0xC002F210 Source: Back Up Database (Differential) Execute SQL Task Description: Executing the query "BACKUP DATABASE [ReportServerTempDB] TO DISK = N'E:\SQL_BACKUP\Capgemini\User Diff Backup\ReportServerTempDB\ReportServerTempDB_backup_201208201200.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'ReportServerTempDB_backup_20120820120015', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Cannot perform a differential backup for database "ReportServerTempDB", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set ... The package execution fa... The step failed.


FailedSad-1073548784) Executing the query "BACKUP DATABASE [ReportServerTempDB] TO DISK = N'E:\\SQL_BACKUP\\Capgemini\\User Diff Backup\\ReportServerTempDB\\ReportServerTempDB_backup_201208201200.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'ReportServerTempDB_backup_20120820120015', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Cannot perform a differential backup for database "ReportServerTempDB", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Steve Hall
Steve Hall
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2822 Visits: 11564
Cannot perform a differential backup for database "ReportServerTempDB", because a current database backup does not exist


Have you taken a FULL backup of this database?

Steve Hall
Linkedin
Blog Site
Jitendra Padhiyar
Jitendra Padhiyar
Mr or Mrs. 500
Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)

Group: General Forum Members
Points: 506 Visits: 674
yes , Full backup taken.
Jitendra Padhiyar
Jitendra Padhiyar
Mr or Mrs. 500
Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)

Group: General Forum Members
Points: 506 Visits: 674
Got it dude... My full backup took some more time to execute and at the same time my differential backup started and thus (I think) due to overlapping of two backup jobs my differential backup fails.

Let me correct if i am wrong.

Thanks in advance.!
Steve Hall
Steve Hall
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2822 Visits: 11564
Thanks for letting me know the cause, I wouldn't have thought of that particular scenario!

Steve Hall
Linkedin
Blog Site
naga.rohitkumar
naga.rohitkumar
SSC Eights!
SSC Eights! (852 reputation)SSC Eights! (852 reputation)SSC Eights! (852 reputation)SSC Eights! (852 reputation)SSC Eights! (852 reputation)SSC Eights! (852 reputation)SSC Eights! (852 reputation)SSC Eights! (852 reputation)

Group: General Forum Members
Points: 852 Visits: 1378
same issue iam facing in one server and for full backup a maintenance plan job is scheduled at morning 10 am some times job get fails [there is not other jobs for the database like differential backup jobs etc.... ] then i manually tries tto execute the backup job but it wont execute and it keep on showing running then i cancel the backup job and go to -- database -- tasks -- backups --full backup iwill try to execute the manual backup then it gets success..

i want to know why it happens even if there is no dependencies on the database

Thanks
Naga.Rohitkumar
Jitendra Padhiyar
Jitendra Padhiyar
Mr or Mrs. 500
Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)

Group: General Forum Members
Points: 506 Visits: 674
Hello Rohit,

What is the size of your disk on which you are taking backup, what is size of your total databases whom you want to backup ?

Let me know above answers might i help you.

Jitendra
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search