SQL 2000 Restore Fails

[mfriedzz]

Does anybody know why I am getting a

W3853 Session was Truncated error on a SQL Restore.

I made sure it was a successful backup. It is only 245 MB.


When I use the Debug log I see the following error:

sql_load_db() - sqlexec failed
$dbasql@MSSQLSERVER: [SQL Server] szSqlState = 37000,fNativeError = 3203, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Read on '\\.\pipe\dbasql@MSSQLSERVER\dbagent0s0' failed, status = 109. See the SQL Server error log for more details.
$dbasql@MSSQLSERVER: free the memory
$dbasql@MSSQLSERVER: sql_load_db(): signal main thread.
$dbasql@MSSQLSERVER: summit sql_load_db failed: rcode=0
$dbasql@MSSQLSERVER: Exit dump/load thread...
$dbasql@MSSQLSERVER: close sem_IO_done and the restore_id=0 is done
$: * DLL_THREAD_DETACH is called.ThreadID=0x7fc
$dbasql@MSSQLSERVER: release_io_unit is called 0
$dbasql@MSSQLSERVER: release io_unit=0
$dbasql@MSSQLSERVER: All reading threads are DONE
$dbasql@MSSQLSERVER: release dumpload unit=0
$dbasql@MSSQLSERVER: Release dumpload_unit is called
$dbasql@MSSQLSERVER: err_handler has been called: server error, severity=0
$dbasql@MSSQLSERVER: DSADisconnectAgent is called
$dbasql@MSSQLSERVER: DSADisconnectAgent return rcode=0
$: * DLL_THREAD_DETACH is called.ThreadID=0x890


Any help would be greatly appreciated.

E-mailed CA earlier.

 

[kevhead]

last time that I restored a sql database it did not like the user name and password that it was backed up with was able to use admin user name and password to restore but spent several hours wondering why it was not working