sql_server_restore_disk [My wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===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:

<sxh bash>
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
</sxh>