I am using MS SQL 2008
I am configuring MS SQL 2008 log shipping method for one of the database
My primary backup is resided on my office PC, and my secondary log shipping server is resided in another location outside of my office's network.
Both primary and secondary servers have MS SQL server 2008 installed.
After I successfully set up backup from primary server, I try to set up secondary server. I have the following trouble
I cannot connect to my secondary server by MS Management Studio. I tried Windows mode and SQL mode with user name and password. But it doesn't work?
Can someone help me with this
Our community of experts have been thoroughly vetted for their expertise and industry experience.