"Not enough storage is available..." HRESULT 0x80070008

Hi,

I have a dump file retrieved from SqlServer 2000. The file name reads something like this: concorde_db_dump.200706070105

I have been trying to import it to SqlServer 2005 but always receiving this message:

Not enough storage is available to process this command.

(Exception from HRESULT: 0x80070008) (mscorlib)

The error details are as follows:

Program Location:

at

System.Runtime.InteropServices.Marshal.ThrowExceptionForHRIn

ternal(Int32 errorCode, IntPtr errorInfo)
at

Microsoft.SqlServer.Management.UI.VSIntegration.Editors.Scri

ptFactory.ProcessDroppedFilesAsyncInternal(StringCollection

filesToOpen)

Does anyone know what's wrong? Thanks!

It would help a great deal if you could give some more information, like:
1. How do you try to import the file (i.e what do you use)
2. In the exception above, it says something about VSIntegration.Editors; are you doing the import using the VS UI?

As I said, some more info would be useful.

Niels
|||Hi Niels

I have tried to create a blank database and use the "Restore" function of Microsoft SQL Server Management Studio 2005 since I suspect it to be a backup file. However, apparently it only works for .bak files, not a file with a time stamp extension.

In your opinion, what kind of file is this? And the file size is about 800 Mb, pretty big (it makes me suspect that there could be a problem with memory insufficiency; I have 1Gb RAM). Thanks.