Cannot copy : Insufficient system resources

Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both fully
patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2 2GB
Fiber NICS teamed
Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
Raid 5 SCSI controller, 4 100 mb NICS teamed
Both servers have lots of room on the partition.
We've been refreshing the development server with fresh production data
every three months. My method for doing this has been to do a local backup of
the production server, then copy the bak file to the development server. This
has been working for several years. The bak file is now 70 GB. The last time
it worked the bak file was around 65 GB. Last night the copy of the bak file
over the network failed about halfway through with a popup:
"Cannot copy prd. bak : Insufficient system resources exist to complete the
requested service" There are no entries in either server's application or
system event logs. I've read the MSFT KB Article 259837 but that doesn't seem
to apply because (a) the failure occured about one hour into the copy process
and (b) both servers are fully patched.
Developers are beating on me to get this done tonight. I suspect in the long
run, I will have to get something like SQL lite speed. But I would like a
quick fix for tonight. I would prefer not to shut down the production db and
copy the individual files.
Here are my thoughts:
1. Would I have better luck if I backed up with a UNC path to the
development server?
2. Can I compress the bak file with something?
Any suggestions?Personally, I prefer working with UNC paths for backups.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"MangroveGeek" <carl@.tenthousandislands.net(DoNotSpam)> wrote in message
news:130BD949-316B-44F2-9117-B30B9477D24C@.microsoft.com...
> Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both
> fully
> patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2
> 2GB
> Fiber NICS teamed
> Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
> Raid 5 SCSI controller, 4 100 mb NICS teamed
> Both servers have lots of room on the partition.
> We've been refreshing the development server with fresh production data
> every three months. My method for doing this has been to do a local backup
> of
> the production server, then copy the bak file to the development server.
> This
> has been working for several years. The bak file is now 70 GB. The last
> time
> it worked the bak file was around 65 GB. Last night the copy of the bak
> file
> over the network failed about halfway through with a popup:
> "Cannot copy prd. bak : Insufficient system resources exist to complete
> the
> requested service" There are no entries in either server's application or
> system event logs. I've read the MSFT KB Article 259837 but that doesn't
> seem
> to apply because (a) the failure occured about one hour into the copy
> process
> and (b) both servers are fully patched.
> Developers are beating on me to get this done tonight. I suspect in the
> long
> run, I will have to get something like SQL lite speed. But I would like a
> quick fix for tonight. I would prefer not to shut down the production db
> and
> copy the individual files.
> Here are my thoughts:
> 1. Would I have better luck if I backed up with a UNC path to the
> development server?
> 2. Can I compress the bak file with something?
> Any suggestions?