Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2011-09-25 : 23:50:23
|
| Dear MemberI have write a copy command in sql2005 to copy backup file of local drive to sharing drive. The copy command is EXEC master..xp_cmdshell 'copy S:\sqlback\db.bak G:\Sqlbackup\ The backup file size is 50 GB.but their is following error"Insufficient system resources exist to complete the requested service." |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-26 : 00:47:52
|
| seems like you dont have enough disk space in drive where you're trying to put backup------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2011-09-26 : 03:14:52
|
| thanks to replyit is not space problem bcoz this drive 200 GB free spaceand backup file size is 50 Gb. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-26 : 04:56:02
|
| Dunno if it uses less resorces, but we use RoboCopy for large files:ROBOCOPY X:\MySourceFolder \\TargetServer\X\MyTargetFolder FileName1 /IPG:80We use IPG:80 to minimise the impact on the network (which in turn increases the elapsed time of the copy). You may not need that. |
|
|
|
|
|
|
copy backup file in local drive to sharing drive