June 14, 2008 at 6:51 am
I'm getting this error when restoring a 19-GB backup from a network share:
Insufficient system resources exist to complete the requested service.
I'm getting the same error when attempting to copy the backup file to a local drive.
I have more than enough disk space and memory on that server.
What could be causing this?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 14, 2008 at 7:22 am
This message is related to the network.
Check the NIC setting on both servers and insure that "link speed & autodetect" is NOT "auto-detect" and that the other parameters are set appropriately.
A network administrator should know the correct values based on the network hardware, especially the router configuration.
SQL = Scarcely Qualifies as a Language
June 14, 2008 at 8:37 am
Carl Federl (6/14/2008)
This message is related to the network.Check the NIC setting on both servers and insure that "link speed & autodetect" is NOT "auto-detect" and that the other parameters are set appropriately.
A network administrator should know the correct values based on the network hardware, especially the router configuration.
Thank you, I'll ask our network people to take a look.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 16, 2008 at 12:03 pm
There is also the possibility that article Q304101 is coming into play...
Basically what the Q article references is running the source machine out of kernel-pageable memory space. You may need to add a registry key to tell the o/s to page out kernel-pageable memory earlier (using a lower percentile).
I've had to do this on a couple of my dbservers that backup/restore over the network and use files that are > 150GB...
Your friendly High-Tech Janitor... 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply