Tivoli Data Protection SQL Server – Restore Database with different name

Leave a comment (0) Go to comments

HOW TO RESTORE SQL Server Database with Different / Alternate NAME from backup created by Tivoli Data Protection (TDP) for Microsoft SQL Server ?

Restore a backup from TDP library is pretty easy but you just need to be familiarized with tool to interact with Data Protection for Microsoft SQL Server.

To Restore a USER Database from a Tivoli, SQL Server Data Protection, you need to

OPEN GUI tool named Data Protection for Microsoft SQL Server; Start Menu\Programs\Tivoli Storage Manager\Data Protection for Microsoft SQL Server

Tivoli Data Protection SQL Server   Restore Database with different name  SQL Server third party Backup Software SQL Server TDP sql restore backup

  1. Click on the ‘Restore Databases’ tab.
  2. Select the ‘Show Active and Inactive’ and ‘Wait for Tape Mounts for File Information’ checkboxes.
  3. Selecting the ‘Show Active and Inactive’ option returns information on all backups within the retention period (not selecting this option will display only the most recent backup)
  4. The ‘Wait for Tape Mounts for File Information’ is required if replacing an existing database
  5. Expand the SQL Servers group.
  6. Expand the server name to display a list of all databases.
  7. Highlight the database being restored. The list of candidate backups is displayed in the right window.
  8. Select the backup from which you need to restore by clicking the checkbox
  9. Ensure the database being restored is selected and the correct backup selected.
  10. Right Click on the Selected Backup and select Restore INTO Tivoli Data Protection SQL Server   Restore Database with different name  SQL Server third party Backup Software SQL Server TDP sql restore backup
  11. Enter the name of the database being restored to and Click OK.Tivoli Data Protection SQL Server   Restore Database with different name  SQL Server third party Backup Software SQL Server TDP sql restore backup
  12. Again Right Click on the selected backup and select Relocate to relocating your database files to a new location and Click OK Tivoli Data Protection SQL Server   Restore Database with different name  SQL Server third party Backup Software SQL Server TDP sql restore backup
  13. Click the Restore button, which will start the Restore Operation and you can Monitor the progress window to confirm completion of the restore; respond to error messages accordingly. Tivoli Data Protection SQL Server   Restore Database with different name  SQL Server third party Backup Software SQL Server TDP sql restore backup

This will successfully restore your selected database from Achieve with a New Database name.


EOF - Tivoli Data Protection SQL Server – Restore Database with different name, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.