Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Logshipping failure

Status
Not open for further replies.

niall5098

IS-IT--Management
Jun 2, 2005
114
IE
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
 
Check that the remote instance is up, and that you can connect to the remote instance correctly from the primary machine.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top