SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



Modifying the backup path in LogShipping Expand / Collapse
Author
Message
Posted Tuesday, November 17, 2009 9:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:19 AM
Points: 114, Visits: 275
Hello,

Is there an easy way to change the backup path after the Log Shipping is configured?

If at all doable will this work....

Thanks In Advance!



Post #820204
Posted Wednesday, November 18, 2009 6:37 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 11, 2010 5:51 AM
Points: 579, Visits: 337
Yes, you can change the Backup Path even after Logshipping configuration and it works well. You need to go to the properties and change the path in Backup Settings tab. You will require to reinitiate the Jobs.
Post #820774
Posted Wednesday, November 18, 2009 6:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:19 AM
Points: 114, Visits: 275
We have lot of servers to change..as long as it works..i think i can figure out a script to do that..

Unless anybody has the script...

THanks



Post #820791
Posted Wednesday, November 18, 2009 7:35 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 11, 2010 5:51 AM
Points: 579, Visits: 337
I am not very good in Scripting. You can read the Log Shipping doc from below URL and then update the script as per your requirements. The article has good scripts for Log Shipping configuration.

http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx
Post #820836
« Prev Topic | Next Topic »


Permissions Expand / Collapse