Link to home
Start Free TrialLog in
Avatar of staticman4414
staticman4414

asked on

How to setup log shipping

I am trying to setup log shipping from one SQL2008 server to another SQL2008 server for disaster recovery purposes. I had read instructions and all seems to setup well, but I keep getting the error below on the primary server.  I am not positive I have everything setup correctly as this is my first time setting this up, but I followed directions found on the net and they seemed straight forwards. Connectivity between the two servers seems fine, but the primary never writes out the first log even.  I did notice a new file was created in the log directory on the secondary server called. "databasenamedatnumbers.tuf"   I am not sure what the TUF file is? But the database name is the one I am testing with so I am sure it is signifigant.

Thanks
Joe

Message
2009-04-06 13:45:01.19      *** Error: Could not retrieve backup settings for primary ID 'aec07870-0176-4225-8b53-ca2d152d81c0'.(Microsoft.SqlServer.Management.LogShipping) ***
2009-04-06 13:45:01.19      *** Error: The specified agent_id AEC07870-0176-4225-8B53-CA2D152D81C0 or agent_type 0 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provider) ***
2009-04-06 13:45:01.19      *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2009-04-06 13:45:01.19      *** Error: The specified agent_id AEC07870-0176-4225-8B53-CA2D152D81C0 or agent_type 0 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provider) ***
2009-04-06 13:45:01.21      *** Error: Could not cleanup history.(Microsoft.SqlServer.Management.LogShipping) ***
2009-04-06 13:45:01.21      *** Error: The specified agent_id AEC07870-0176-4225-8B53-CA2D152D81C0 or agent_type 0 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provider) ***
2009-04-06 13:45:01.21      ----- END OF TRANSACTION LOG BACKUP   -----

Exit Status: 1 (Error)
ASKER CERTIFIED SOLUTION
Avatar of Brendt Hess
Brendt Hess
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial