August 21, 2012 at 12:55 am
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.
Failed:(-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.
August 21, 2012 at 3:23 am
yes , Full backup taken.
August 21, 2012 at 3:44 am
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.!
April 16, 2013 at 5:37 am
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
April 18, 2013 at 2:57 am
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply