Red Gate forums :: View topic - Scheduled Restore Jobs
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Scheduled Restore Jobs

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
tleblanc



Joined: 04 Oct 2011
Posts: 13

PostPosted: Mon May 07, 2012 7:19 pm    Post subject: Scheduled Restore Jobs Reply with quote

First of all, THANKS for building this into 7.0!

I'm restoring a back-up of our production database to a different server and with the previous version I used the work-around of using SQL Server Agent job calling SQB and then executing other scripts to adopt orphaned users and do some other clean-up.
The new Scheduled Restore Job tells me that I have orphaned users but that's as far as it goes. What is the recommendation here? Should I stick with the Agent call to SQB? Can I modify the job that SQL Backup created by adding the steps from my old job into this one? Will modifying the SQL Backup job with additional steps cause problems if I then edit it in the UI?

Feature Request: add ability to setup these additional steps in the UI or provide a mechanism for us to get our orphaned users adopted (please sir, can I have some more?)
Back to top
View user's profile Send private message
Marianne



Joined: 03 Oct 2011
Posts: 45

PostPosted: Tue May 08, 2012 2:59 pm    Post subject: Reply with quote

Hi,

You can modify a restore job created by SQL Backup by adding additional steps (for example, using SQL Server Management Studio). As long as the RESTORE command remains a separate job step, you can then edit the job using the SQL Backup UI. From the Jobs tab, double-click the job to open the Edit Restore Jobs wizard. You will only be able to edit those commands which are supported by the SQL Backup UI.

Similarly, any existing restore jobs where the RESTORE command is a separate job step should appear in the Jobs tab of the SQL Backup UI. Double-click a job to edit it. Again, you will only be able to edit commands supported by the UI.

Thank you very much for your feedback.

Cheers,

Marianne
_________________
Marianne Crowder
Red Gate Software Limited
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group