Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup failed Expand / Collapse
Author
Message
Posted Tuesday, August 21, 2012 12:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
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.
Post #1347590
Posted Tuesday, August 21, 2012 1:15 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 1,482, Visits: 8,483
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?


BrainDonor
Linkedin
Blog Site
Post #1347599
Posted Tuesday, August 21, 2012 3:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
yes , Full backup taken.
Post #1347652
Posted Tuesday, August 21, 2012 3:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
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.!
Post #1347662
Posted Tuesday, August 21, 2012 7:17 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 1,482, Visits: 8,483
Thanks for letting me know the cause, I wouldn't have thought of that particular scenario!

BrainDonor
Linkedin
Blog Site
Post #1347773
Posted Tuesday, April 16, 2013 5:37 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 7:03 AM
Points: 590, Visits: 1,327
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
Post #1442695
Posted Thursday, April 18, 2013 2:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
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
Post #1443687
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse