sql server log shipping

Posted by voam on Server Fault See other posts from Server Fault or by voam
Published on 2010-01-06T17:04:35Z Indexed on 2010/05/12 17:24 UTC
Read the original article Hit count: 293

Filed under:
|

I am setting up log shipping with two 2008 sql servers connecting with a vpn. As far as I know as long as the sql agent is able to access the share on the primary/secondary servers everything will work. When I set up the Log shipping on the primary server using SQL Mangagement Studio, before I can set any of the "Secondary Database Settings" it asks me to connect to the secondary server. But I really don't want to open up the connection to the secondary server. I will be initialing this secondary database with a backup so as long as the transaction logs get copies everything should work. How to I work around the GUI not enabling any of the settings for the secondary server until I actually connect to it?

Thanks in advance!

© Server Fault or respective owner

Related posts about sql-server

Related posts about log-shipping