dhoward007
Programmer
I have setup log shipping on a primary and secondary server. I am testing the fail over and am having trouble with the sp_resolve_logins procedure. I can successfull bring up the standby server as the primary but when I use the resolve logins procedure i run into problems.
Has anyone experienced problems with this? Below is the error. I am following the process that microsoft outlines in a whitepaper about log shipping. I wanted to post my problem here before calling Microsoft. I am stuck..
Server: Msg 4866, Level 17, State 66, Line 1
Bulk Insert fails. Column is too long in the data file for row 1, column 1. Make sure the field terminator and row terminator are specified correctly.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.].
The statement has been terminated.
Has anyone experienced problems with this? Below is the error. I am following the process that microsoft outlines in a whitepaper about log shipping. I wanted to post my problem here before calling Microsoft. I am stuck..
Server: Msg 4866, Level 17, State 66, Line 1
Bulk Insert fails. Column is too long in the data file for row 1, column 1. Make sure the field terminator and row terminator are specified correctly.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.].
The statement has been terminated.