Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
skyw
Starting Member
8 Posts |
 Posted - 2009-01-12 : 08:18:17
|
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.Message2009-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. |
|
|
skyw
Starting Member
8 Posts |
Posted - 2009-01-12 : 08:53:02
|
Due to the account I used to connect to the secondary server. It should be sa.  |
 |
|
|
|
|
|
Management Studio could not retrieve information