luni, 27 februarie 2017

Backup file size bigger than database size solved SQL server

http://bit.do/dfuhs Secret discount page at HandyBackup.
Issue is caused because of NOINIT option. But this can be used as proper backup way to keep different version of databackup. Script used BACKUP DATABASE SampleDB TO DISK = 'D:\BackupFolder\Sample.bak' WITH NOINIT, NAME = N'SAMPLEDB' RESTORE HEADERONLY FROM DISK = 'D:\BackupFolder\Sample.bak' Video to restore backup on previous data version Video link :https://youtu.be/7HuyQhQlwZk

Niciun comentariu:

Trimiteți un comentariu