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