[SQL2005] Backup Diff MSDB erreur

[aurels01]

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

[kagemaru]

le 1er backup que tu fais est déjà en différentiel :

Code :

1
2
3
4
5
6
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

faut juste enlever le différential :

Code :

1
2
3
4
5
6
BACKUP DATABASE [msdb]
TO DISK = N'I:\MSSQL\msdb2.bak'
WITH NOFORMAT, INIT,
NAME = N'msdb-Differential Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

ce n'est pas commun de faire un backup diff de la msdb (en général toute petite sauf si les logs du dts s'accumulent...)

[aurels01]

Hello,

Oui dsl je me suis trompe dans le copier / coller
Je fais bien un full suivi d un diff

Merci

[kagemaru]

est-ce que tu peux envoyer le set de commandes complet avec tous les messages ? merci

[aurels01]

Pour le Full:

BACKUP DATABASE [msdb] TO DISK = N'I:\MSSQL\msdb.bak'
WITH NOFORMAT, NOINIT, NAME = N'msdb-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO


Envent Log:

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 18264
Date: 7/27/2007
Time: 9:51:04 AM
User: XXX
Computer: XXXX
Description:
Database backed up. Database: msdb, creation date(time): 2005/10/14(01:54:05), pages dumped: 1043, first LSN: 164:328:179, last LSN: 164:408:1, number of dump devices: 1, device information: (FILE=8, TYPE=DISK: {'I:\MSSQL\msdb.bak'}). This is an informational message only. No user action is required.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 58 47 00 00 0a 00 00 00 XG......
0008: 07 00 00 00 48 00 50 00 ....H.P.
0010: 34 00 30 00 35 00 39 00 4.0.5.9.
0018: 00 00 07 00 00 00 6d 00 ......m.
0020: 61 00 73 00 74 00 65 00 a.s.t.e.
0028: 72 00 00 00 r...





Pour le Diff

BACKUP DATABASE [msdb] TO DISK = N'I:\MSSQL\msdb.bak'
WITH DIFFERENTIAL , NOFORMAT, NOINIT,
NAME = N'msdb-Differential Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

Message:

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.

From Event Log


Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 3041
Date: 7/27/2007
Time: 9:47:03 AM
User: XXX
Computer: XXX
Description:
BACKUP failed to complete the command BACKUP DATABASE msdb WITH DIFFERENTIAL. Check the backup application log for detailed messages.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: e1 0b 00 00 10 00 00 00 á.......
0008: 07 00 00 00 48 00 50 00 ....H.P.
0010: 34 00 30 00 35 00 39 00 4.0.5.9.
0018: 00 00 05 00 00 00 6d 00 ......m.
0020: 73 00 64 00 62 00 00 00 s.d.b...

Merci

[kagemaru]

heure de ton backup full : Time: 9:51:04 AM
heure de ton backup diff : Time: 9:47:03 AM

Tu dois faire le full avant le(s) diff.

[aurels01]

J ai essayer de faire un Full et apres un diff mais la meme erreur persite

Merci

[kagemaru]

faire un backup full puis un diff est en général une opération simple. Et comme pour le moment tu n'as posté que des exemples où il y a un problème, j'aurais tendance à dire que tu fais ptét une opération de traviol ...
est-ce que tu peux poster les 2 commandes lancées dans un analyseur de requêtes ainsi que le resultat de l'analyseur, et si possible en faisant un backup WITH INIT dans 2 fichiers distincts ?