Hi. How does one restore to a point in time on a different server?
Troyd73
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:
Answers
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.
Redgate Software
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com