Click here to Skip to main content
15,936,197 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I'm trying to configure Log Shipping in SQL 2005. I have 2 servers,
each running an instance of SQL 2005. The services are all high-
permissions accounts.

After I configure Log shipping for a database, the process completes
and all tasks (Backup, copy, restore) Are listed as successful.

However, if I go back in to the log shipping properties on the master
server and click on the secondary server instance, I receive:

"Management Studio could not retrieve information about secondary
database [SERVERNAME].[DBNAME]"

It also appears that the copy job is not executing properly - it isn't
listed under the report as being applicable for any of the three
servers involved, and the jobs are failing with a thoroughly not
useful error message.

I'd like to get this set up with 2005's log shipping.

Thanks,
SREE
Posted
Updated 6-Jan-15 0:41am
v2
Comments
Nathan Minier 6-Jan-15 7:50am    
Are both servers accessed with the same domain account, so that the same context will have the same permissions on both?

If not, you'll need to make sure that a Linked Server is defined on the server where the query is executed, and that credentials with the appropriate permissions are used to establish the link.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900