Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| 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=== | ===Overview=== | ||
| - | As any 3rd party tape database backup solution. The IBM Tivoli Data Protector, doesn' | + | As any 3rd party tape database backup solution. The IBM Tivoli Data Protector, doesn' |
| 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. | 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 :) | Here is how I have been able to use it to generate me the command which I used in the end :) | ||
| Line 24: | Line 24: | ||
| <sxh bash> | <sxh bash> | ||
| - | Restore-DpSqlBackup Bolton_Belgium -Full | + | Restore-DpSqlBackup Bolton_Belgium |
| + | -Full | ||
| -BackupDestination TSM | -BackupDestination TSM | ||
| -BackupMethod legacy | -BackupMethod legacy | ||
| Line 39: | Line 40: | ||
| </ | </ | ||
| + | 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 " | ||