To restore a differential backup, you must first restore a full backup while ensuring that the databases is NOT recovered. The most recent differential backup is then applied to the database.
RESTORE DATABASE PUBS FROM DISK='C:\DEMO\BACKUP\PUBSDIFF.BAK' RECOVERY
The first command restore Full backup, leaving the database unrecovered. The second command applies a differential backup and then recovers from database.
No comments:
Post a Comment