The provider ran out of memory. [SQLSTATE 42000] (Error 7399).

[jimmYLepp]

I have two SQL Server 7.0, one is the primary app server (machine A) and the other is A's warm standby (machine B). Currently today all of my warm standby jobs fail when they are trying to copy the transaction file from A to B. Here is the complete error :


OLE DB provider 'STREAM' reported an error.
The provider ran out of memory. [SQLSTATE 42000] (Error 7399).



Has anybody seen this before?

jimmY

 

[JayKusch]

How are you "copying" the log files?

Thanks

J. Kusch

 

[jimmYLepp]

currently we are using robocopy, which and the syntax would be


robocopy v:\mssql\source f:\mssql\destination db_backup.bak


where v is a permenantly mapped drive.


jimmY