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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 copy backup file in local drive to sharing drive

Author  Topic 

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2011-09-25 : 23:50:23
Dear Member

I 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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2011-09-26 : 03:14:52
thanks to reply

it is not space problem bcoz this drive 200 GB free space
and backup file size is 50 Gb.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-26 : 04:16:26
might be this

http://support.microsoft.com/kb/304101

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

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:80

We 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.
Go to Top of Page
   

- Advertisement -