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.tu f" 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-c a2d152d81c 0'.(Micros oft.SqlSer ver.Manage ment.LogSh ipping) ***
2009-04-06 13:45:01.19 *** Error: The specified agent_id AEC07870-0176-4225-8B53-CA 2D152D81C0 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.SqlServ er.Managem ent.LogShi pping) ***
2009-04-06 13:45:01.19 *** Error: The specified agent_id AEC07870-0176-4225-8B53-CA 2D152D81C0 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.SqlServ er.Managem ent.LogShi pping) ***
2009-04-06 13:45:01.21 *** Error: The specified agent_id AEC07870-0176-4225-8B53-CA 2D152D81C0 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)
Thanks
Joe
Message
2009-04-06 13:45:01.19 *** Error: Could not retrieve backup settings for primary ID 'aec07870-0176-4225-8b53-c
2009-04-06 13:45:01.19 *** Error: The specified agent_id AEC07870-0176-4225-8B53-CA
2009-04-06 13:45:01.19 *** Error: Could not log history/error message.(Microsoft.SqlServ
2009-04-06 13:45:01.19 *** Error: The specified agent_id AEC07870-0176-4225-8B53-CA
2009-04-06 13:45:01.21 *** Error: Could not cleanup history.(Microsoft.SqlServ
2009-04-06 13:45:01.21 *** Error: The specified agent_id AEC07870-0176-4225-8B53-CA
2009-04-06 13:45:01.21 ----- END OF TRANSACTION LOG BACKUP -----
Exit Status: 1 (Error)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.