Differences

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

--- sql_server_restore_tape_tdpsql [2019/03/22 13:54] – 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 to use.
+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 11: / Line 11: @@
 </sxh>
-After the GUI is 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.
+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.
 After you mark them, right click and choose Restore to different location/instance.
 This will give you larger menu, from which you can configure more things, like relocation directories, PIT settings and so on.
@@ Line 21: / Line 24: @@
 <sxh bash>
-Restore-DpSqlBackup Bolton_Belgium -Full
+Restore-DpSqlBackup Bolton_Belgium
+-Full
 -BackupDestination TSM
 -BackupMethod legacy
@@ Line 36: / 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.