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

Differential Restores

ChrisAVWoodChrisAVWood Posts: 361
edited September 14, 2009 9:36AM in SQL Backup Previous Versions
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
English DBA living in CANADA

Comments

Sign In or Register to comment.