Overview
Using a file backup, backup / restore/ recover becomes way easier since it is natively support and we don't need any 3rd part software (most of which are hard to maintain and the support is very “questionable” :) )
Backup
Restore
Restore from Disk is done as follows:
RESTORE DATABASE [Bolton_Belgium_20190320] FROM TAPE = N'TDPSQL-00003814-0000' WITH FILE = 1, MOVE N'Bolton_Belgium_Data' TO N'I:\MSSQL10_50.SQLNAVISIONPROD\MSSQL\DATA\CH1393024\Bolton_Belgium_20190320.mdf', MOVE N'Bolton_Belgium_Log' TO N'L:\MSSQL10_50.SQLNAVISIONPROD\MSSQL\Data\CH1393024\Bolton_Belgium_20190320_1.ldf', MOVE N'Bolton_Belgium_1_Data' TO N'I:\MSSQL10_50.SQLNAVISIONPROD\MSSQL\DATA\CH1393024\Bolton_Belgium_20190320_2.ndf', NORECOVERY, NOUNLOAD, STATS = 10 GO RESTORE LOG [Bolton_Belgium_20190320] FROM TAPE = N'TDPSQL-000029EC-0000' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10 GO RESTORE LOG [Bolton_Belgium_20190320] FROM TAPE = N'TDPSQL-00002E20-0000' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10 GO RESTORE LOG [Bolton_Belgium_20190320] FROM TAPE = N'TDPSQL-00005624-0000' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10 GO RESTORE LOG [Bolton_Belgium_20190320] FROM TAPE = N'TDPSQL-00001A70-0000' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10 GO RESTORE LOG [Bolton_Belgium_20190320] FROM TAPE = N'TDPSQL-00002F2C-0000' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10 GO RESTORE LOG [Bolton_Belgium_20190320] FROM TAPE = N'TDPSQL-00003464-0000' WITH FILE = 1, NOUNLOAD, STATS = 10 GO