Differences

This shows you the differences between two versions of the page.

--- sql_server_restore_tape_tdpsql [2019/03/22 16:55] – andonovj
+++ sql_server_restore_tape_tdpsql [2019/10/18 20:04] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ===Overview===
 As any 3rd party tape database backup solution. The IBM Tivoli Data Protector, doesn't fall short on SUCKING at its job.
 The GUI might not work, the exe should be started with special CFG and OPT files so it will see the correct backups and so on and so on.
 Here is how I have been able to use it to generate me the command which I used in the end :)
@@ Line 12: / Line 12: @@
 After the GUI has started, you can go to recover, SELECT ALL BACKUPS and mark all the backups to restore which are needed, which means:
 Full backup + All log backups to the specified point.
@@ Line 23: / Line 24: @@
 <sxh bash>
-Restore-DpSqlBackup Bolton_Belgium -Full
+Restore-DpSqlBackup Bolton_Belgium
+-Full
 -BackupDestination TSM
 -BackupMethod legacy
@@ Line 38: / Line 40: @@
 </sxh>
+P.S. This script, will restore you the full backup and won't recover, meaning you can apply the transaction log backups and then finish with empty recover to open the database.
+Please keep in mind that executing this command or the steps above only will leave the database in "Restoring" mode, meaning you will have to do empty recover, to open it.