Salut a tous,
J ai un probleme en backupant la base MSDB.
Je fais un Full de la MSDB:
BACKUP DATABASE [msdb]
TO DISK = N'I:\MSSQL\msdb2.bak'
WITH DIFFERENTIAL , NOFORMAT, INIT,
NAME = N'msdb-Differential Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
OK
Et apres j essai un Diff et je recois ce message d erreur:
Msg 3035, Level 16, State 1, Line 1
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.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Pour info ma base est en recovery model Simple
Je vous remercie pour votre aide
Aurels
Partager