How can we help you today? How can we help you today?

Differential Restores

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
ChrisAVWood
0

Comments

2 comments

Sort by
  • petey
    Correct. The syntax to restore a differential backup to a database in read-only/recovery mode is simple RESTORE DATABASE ... FROM DISK = ...
    petey
    0
  • ChrisAVWood
    Thanks Petey.
    ChrisAVWood
    0

Add comment

Please sign in to leave a comment.