Differential Restores

ChrisAVWood

Hi,

This is probably a dumb question but I could not find the exact syntax for a differential restore.

As a differential backup is a BACKUP DATABASE[....] TO .... WITH DIFFERENTIAL I think that I can assume that the correct syntax would be RESTORE DATABASE[....] FROM .... without having to specify that this is a differential. Obviously the differential restore comes after a RESTORE DATABASE[....] FROM .... WITH NORECOVERY.

Thanks

Chris

petey

Correct. The syntax to restore a differential backup to a database in read-only/recovery mode is simple RESTORE DATABASE ... FROM DISK = ...

ChrisAVWood

Thanks Petey.