Hi. How does one restore to a point in time on a different server?

Troyd73Troyd73 Posts: 2 Bronze 1
in SQL Backup
 I have multiserver activation enabled for the 2 servers. Issue is our production server is offline and we need to restore to a different server
Tagged:
· Share on Twitter

Answers

  • RichardLRichardL Posts: 417 Gold 4
    Hi @Troyd73

    Thanks for your post. 

    If you don't get a replyt from the community can you gather the specific with screenshots and your product version and send us a ticket please so that a product specialist can hep you out? 

    Kind regards

    Richard. 
    Customer Support
    Redgate Software
    · Share on Twitter
  • Troyd73Troyd73 Posts: 2 Bronze 1
    Hi. I sent a ticket to Sarah. Regards
    · Share on Twitter
  • Eddie DEddie D Posts: 1,807 Rose Gold 5
    edited May 2, 2018 11:49AM

    Hi Troy

    To restore backup files to a different server to a point in time, please follow the steps below:

    1.  Open the SQL Backup GUI.

    2.  Run the Restore Wizard.  In step 1 of the Restore wizard (Select backups to restore), change the drop down box from 'select from backup history' to 'Browse for backup files to restore'.  The appearance of the dialog box will change.

    3.  Still on Step 1, click the 'Add files' button.

    4.  Browse to locate the backup files you wish to restore. You can choose multiple files.

    5.   In the background the selected backup files are checked to ensure that they are valid, as confirmed by a 'tick' on a green circle. Now click OK. If the files are invalid there will be a 'X' on a red circle.

    6.  Step 2 of the Restore Wizard appears. By default the wizard selects the option to 'Overwrite existing database'. As the database you wish to restore too may not be listed, you can select the second option to 'Create new database' and enter the database name.

    7. In the Filegroups and files section, modify the locations for the Primary, Transaction Log and if configured the filegroups as required. Click Next.

    8.  Step 3 of the wizard appears. Confirm the 'Recovery completion state'. 

    9.  Still on Step 3, as you wish to restore to a point in time, enable that option and configure the desired time and e-mail notification if so desired. Click Next.

    10. The final step, step 4 appears. Review the summary to ensure what you wish to be restored is correct. Go back to the relevant step if any changes are required.  You can also select the Script tab to review the T-SQL commands that SQL Backup will use to perform the Restore.  When you are happy, Click finish.

    I hope the above helps.

    I have also answered the support ticket you submitted.

    Many Thanks

    Eddie

    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.