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



Comments

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



    ReplyDelete

Post a Comment

Dear User,

Thank you very much for your kind response

Popular posts from this blog

Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c

Oracle 10g/11g Linux:SMS the alert logs ORA- errors generated in timestamp

Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server.