Im trying to take differential back up on sql 2005 server with SP4 (Workgroup Edition) but it gives me below error...
Msg 3035, Level 16, State 1, Line 1 Cannot perform a differential backup for database "ABC", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally.
Fullbackup exists but its still giving above message. I found this article but it seems this is applicable for sql server 2005 with no service pack.
I got below error when I tried to install above hotfix.
This update requires s开发者_如何学Cervice pack 0. The service pack for product instance MSSQLSERVER is 4.Download the update for service pack 4.
First try a full backup and then the differential backup. It is possible that your backup chain to the existing full backup is somehow broken.
精彩评论