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