If we want to restore database with differential backup then first we need to restore associated fill backup with NORECOVERY option.
Below is example...
Only after that we can apply Differential backup on the database...
Below is the example...
--------------------------------------------------------------------
Below is example...
--------------------------------------------------------------------
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
WITH NORECOVERY
--------------------------------------------------------------------
Only after that we can apply Differential backup on the database...
Below is the example...
--------------------------------------------------------------------
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks_Diff.BAK'
--------------------------------------------------------------------
No comments:
Post a Comment
If you have any doubt or question, please contact us.