Restore Incremental Backup to original Database

1.Create Database from SSMS.

2.Restore Database.Use Full Backup first to restore.












Use this script

RESTORE DATABASE [FRMINCRBAK]
FROM  DISK = N'@@\File.BAK'
WITH  FILE = 1,  NORECOVERY,  NOUNLOAD,  REPLACE,  STATS = 10
GO
 

3. Restore Incremental Backups.




Use this script



RESTORE DATABASE [FRMINCRBAK] FROM 
DISK = N'@@\INCR.BAK'
 WITH  FILE = 1,  NORECOVERY,  NOUNLOAD,  STATS = 10
GO

Last Incremental backup with recovery.







Use script

RESTORE DATABASE [FRMINCRBAK]
FROM  DISK = N'@@\INCR1.BAK'
WITH  FILE = 1,  NOUNLOAD,  STATS = 10
GO



1 comment:

  1. Cloud Ace Technologies is offering Implementation Services on Cloud Computing, Cloud Services, IT Security, Storage solutions
    Backup



    ReplyDelete

Dear User,

Thank you very much for your kind response