Forum Discussion
Cannot perform a differential backup for database ”myDb“
Execute query "BACKUP DATABASE [CreditSummary] TO DISK = N'R: \\ Ba ..." failed with the following error: "Can not perform differential backup of database" CreditSummary "because there is no current database backup. Please remove the WITH DIFFERENTIAL option And then issue BACKUP DATABASE to perform a full backup of the database.
BACKUP DATABASE is aborting abnormally. The reason for the failure may be that the query itself has a problem, the ResultSet attribute is not set correctly, the parameter is not set correctly, or the connection is not established correctly
- Argelo Royce BautistaCopper ContributorSomething tells me that you need to perform a full backup before you perform a differential backup...
- Christian AraujoCopper Contributor
It looks like the backup chain got broken at some point and you need to generate a new full backup
- vinay babu kommupoguCopper Contributor
Try adding this registry key in the affected server.
[HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\BCDRAGENT]
"USEVSSCOPYBACKUP"="TRUE"