53GB

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

Exit mobile version