File Table Database Backup and Restore
There is not much change in restore process, the additional process is to backup and restore file stream file and data. Enable dbcc traceon(3004, 3605, -1) to write backup and restore background process in error log. RESTORE DATABASE [SQL2016DB] FROM DISK=’H:\DatabaseBackup_FileTable\SQL2016DB_FULL.BAK’ WITH REPLACE,RECOVERY,STATS=5 Backup Background Process 2015-10-21 00:33:42.940 spid54 Backup(SQL2016DB): BACKUP DATABASE started 2015-10-21 00:33:42.940 spid54 […]