Restoring SQL database backup to previous data version



Restoring SQL database backup to previous data version

Restoring SQL database backup to previous data version

Script used in this videos are mentioned below:

BACKUP DATABASE SampleDB TO DISK = ‘D:BackupFolderDBBackup.bak’ WITH
NOINIT,
NAME = N’Sample DB – FULL Backup’

RESTORE HEADERONLY FROM DISK = ‘D:BackupFolderDBBackup.bak’

RESTORE DATABASE SampleDB FROM DISK = ‘D:BackupFolderDBBackup.bak’
WITH REPLACE, FILE=2

Comments are closed.