Differential Restores
ChrisAVWood
Posts: 361
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
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
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8