HI All,
I have sql server log shipping setup on 2 instances on 2005. the lsbackup job is failing with the following error:
Message
2011-01-05 22:29:52.01 *** Error: Could not retrieve backup settings for primary ID '20f7d1d4-03ff-482e-a9f7-02ba1628fbda'.(Microsoft.SqlServer.Management.LogShipping) ***
2011-01-05 22:29:52.01 *** Error: Failed to connect to server <servername>.(Microsoft.SqlServer.ConnectionInfo) ***
2011-01-05 22:29:52.01 *** Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)(.Net SqlClient Data Provider) ***
2011-01-05 22:29:52.01 ----- END OF TRANSACTION LOG BACKUP -----
I can create transaction log backup using a normal maintenance plan backup.
The user i am using to run the job is the domain administrator user and should have all the rights necessary.
any help would be appreciated.
Thanks
I have sql server log shipping setup on 2 instances on 2005. the lsbackup job is failing with the following error:
Message
2011-01-05 22:29:52.01 *** Error: Could not retrieve backup settings for primary ID '20f7d1d4-03ff-482e-a9f7-02ba1628fbda'.(Microsoft.SqlServer.Management.LogShipping) ***
2011-01-05 22:29:52.01 *** Error: Failed to connect to server <servername>.(Microsoft.SqlServer.ConnectionInfo) ***
2011-01-05 22:29:52.01 *** Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)(.Net SqlClient Data Provider) ***
2011-01-05 22:29:52.01 ----- END OF TRANSACTION LOG BACKUP -----
I can create transaction log backup using a normal maintenance plan backup.
The user i am using to run the job is the domain administrator user and should have all the rights necessary.
any help would be appreciated.
Thanks