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