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
Cloud Ace Technologies is offering Implementation Services on Cloud Computing, Cloud Services, IT Security, Storage solutions
ReplyDeleteBackup
This is more helpful for basic programmer.. Good information.
ReplyDeleteVisual FoxPro to .Net
VB.Net Migration
VB6 Migration
SQL Server Migration
Pretty decent addition to incremental backups guide, thanks!
ReplyDelete