Restoring SQL database backup to previous data version

Опубликовано: 11 Октябрь 2024
на канале: techsapphire
32,871
80

Script used in this videos are mentioned below:

BACKUP DATABASE SampleDB TO DISK = 'D:\BackupFolder\DBBackup.bak' WITH
NOINIT,
NAME = N'Sample DB - FULL Backup'

RESTORE HEADERONLY FROM DISK = 'D:\BackupFolder\DBBackup.bak'

RESTORE DATABASE SampleDB FROM DISK = 'D:\BackupFolder\DBBackup.bak'
WITH REPLACE, FILE=2