Post reply

Management Studio could not retrieve information about secondary database

  • January 12, 2009 at 6:23 am

    #198208

    Hi,

    I am getting the following error for my log shipping configuration.

    Management Studio could not retrieve information about secondary database.

    I have successfully set up the log shipping but when I try to modify the configuration of secondary it throws up this error.

    Also, my LS_Copy job is failing and it gives the following error message.

    Message

    2009-01-12 13:11:02.05*** Error: Could not retrieve copy settings for secondary ID 'c5ab865c-fd44-4590-b600-acb8fefb3c63'.(Microsoft.SqlServer.Management.LogShipping) ***

    2009-01-12 13:11:02.05*** Error: The specified agent_id C5AB865C-FD44-4590-B600-ACB8FEFB3C63 or agent_type 1 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provider) ***

    2009-01-12 13:11:02.05*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***

    2009-01-12 13:11:02.05*** Error: The specified agent_id C5AB865C-FD44-4590-B600-ACB8FEFB3C63 or agent_type 1 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provider) ***

    2009-01-12 13:11:02.05*** Error: Could not cleanup history.(Microsoft.SqlServer.Management.LogShipping) ***

    2009-01-12 13:11:02.05*** Error: The specified agent_id C5AB865C-FD44-4590-B600-ACB8FEFB3C63 or agent_type 1 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provi

    Since I have other jobs running under the same service account between these two servers hence the permission with which the SQL Agent Service account is running should not be an issue. That is, all other LS_Copy jobs (for other Dbs) running under the same service account are working fine.

    Please help.

  • September 2, 2010 at 2:44 am

    #1215450

    I have same problem.

    The error message "management studio could not retrieve information about secondary database ...."

    Maybe any solution for this case.

    Tks.

  • September 2, 2010 at 3:34 am

    #1215467

    One possibility is a situation as in the below link-

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=117064

    Please go through the last post in this link and check if that's what is happening.

    -

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply