[SQL 2005] backup Diff on MSDB doesnt work

Hello all,

I need help concerning a differential backup on a MSDB database.

I received this message when I tried to backup it

Log from Windows

Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
Date: 8/1/2007
Time: 2:03:37 PM
User: N/A
Computer: XXX

Description:
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=9028. Thread=5928. Client. Instance=. VD=Global\Data Protector_(DEFAULT)_msdb_14_00_21.

Log from DataProtector

Normal] From: XXX "(DEFAULT)" Time: XXX
SQL statement:
BACKUP DATABASE [msdb] TO
VIRTUAL_DEVICE = "Data Protector_(DEFAULT)_msdb_06_00_14"
WITH NAME = 'Data Protector: 2007/08/01 0064', DIFFERENTIAL, BLOCKSIZE = 4096, MAXTRANSFERSIZE = 65536;

[Warning] From: XXX "(DEFAULT)" Time: XXX
Error has occurred while executing a SQL statement.
Error message: '<Microsoft SQL-DMO (ODBC SQLState: 42000):bdb>
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot perform a differential backup for database "msdb", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.'

Ive tried to do a full followed straight after by a diff but doent help.

Thank you for your help

yes you can take differential but for master you can take only full backup ..........whats in the error log ? ? ? you need to take a full backup and then subsequently differential backup

|||

Yes we can, I do it for many servers

|||

The error is pretty explicit about what the problem is.

A differential backup is defined as the set of changes SINCE THE LAST FULL BACKUP.

If you've never done a full backup, there is nothing to base the differential on and it won't work.

Do a full backup of MSDB, and then your differentials should work.

|||

Hi thank you to replay.

That what I do, a full and after a diff, that why I don't understand why I doesnt find any base

Thank you

|||

Is the database recovery set to FULL? Simple won't do it (it actually reset the status field needed).

|||

FULL recovery model applies to log backups, not to differential backups.

In fact, there is no way to clear the differential base once it is set.

What you're attempting to do should work just fine.

Please try it from Management Studio query window and paste the commands and response.

Thanks,

Kevin

|||

Kevin Farlee wrote:

FULL recovery model applies to log backups, not to differential backups.

In fact, there is no way to clear the differential base once it is set.

Thanks for the correction. Somehow, I was thinking the OP wants to backup log for msdb (you can't 'cuz it's simple). Duh!