|
|
|
SSC-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!
|
|
|
|
|
Mr 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.
|
|
|
|
|
SSC-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
|
|
|
|
|
Mr 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
|
|
|
|