What are the challenges you face when working across database platforms? Take the survey

Differential Restores

ChrisAVWoodChrisAVWood Posts: 361
edited September 14, 2009 9:36AM in SQL Backup Previous Versions

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.


English DBA living in CANADA


Sign In or Register to comment.