Error while running RESTORE DATABASE
I'm trying to use the sqb2mtf.exe program to restore our databases to a development server. Sqb2mtf works fine, and generated 32 .BAK files (we run SQL Backup at 32 threads). When I try to restore the database back to SQL Server 2000 on the development server, I get the following error
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData (CheckforData()). Server: Msg 11, Level 16, State 1, Line 0 General network error. Check your network documentation. Connection Broken
The code I am trying to execute is
RESTORE DATABASE Tackleshop from disk='g:\backup~1\dbs\tackleshop_00.bak', disk='g:\backup~1\dbs\tackleshop_01.bak', ... disk='g:\backup~1\dbs\tackleshop_31.bak'
My database is roughly 4 GB compressed, 32 GB uncompressed (I know, *huge*). Has anyone experienced any problems like this before? Perhaps I am running out of memory? I'm not sure.
Thanks in advance.
FishUSA.com - America's Tackle Shop!