SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Backup File Transfer
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pdset
Constraint Violating Yak Guru

307 Posts

Posted - 05/09/2013 :  18:22:46  Show Profile  Reply with Quote
We have 2008 R2 SQL Server built on WINDOWS 2008 R2 Enterprise Edition.

We do backups being stored and in the process of TRANSFERRING these .BAK files were unable to get copied across within the Data Centre arena.

Moreover the file size of more than 20 GB is also unable to process.

The above things were easily done using WINDOWS 2003 Server but this is the latest beauty of Microsoft new invention on 2008 Server.

So we have compressed the file to less than 20GB and still while transferring then also it won't copy.

Is there any method this can be copied to another server within the same network.

Your suggestions much appreciated.

srimami
Posting Yak Master

160 Posts

Posted - 05/10/2013 :  03:26:00  Show Profile  Reply with Quote
There shouldn't any problem to transfer the .bak files in 2008 env. Please ensure you run with administrative rights, it works.

Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2079 Posts

Posted - 05/10/2013 :  13:57:29  Show Profile  Visit jackv's Homepage  Reply with Quote
What error message are you getting? Are you trying to copy through SQL Server or from Windows?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

pdset
Constraint Violating Yak Guru

307 Posts

Posted - 05/15/2013 :  19:29:28  Show Profile  Reply with Quote
Apologies to get back little absent.

I was trying to copy the .BAK file from Windows Environment. Though there is enough Disk space for the file and also the file is within the Data Centre arena, after copying it in middle of around 50 - 60 percent and it has got this error.

Error 0x8007046A: Not enough Server Storage is available to process this Command.

I have verified from the Friendly suggestive pages from the net, and it really didn't helped me either to suppress.

Any further suggestions. Thanks all.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 05/15/2013 :  20:24:20  Show Profile  Visit russell's Homepage  Reply with Quote
saw this?

http://blogs.technet.com/b/markrussinovich/archive/2009/03/26/3211216.aspx

Edited by - russell on 05/15/2013 20:31:57
Go to Top of Page

AJSpruit
Starting Member

United Kingdom
3 Posts

Posted - 05/16/2013 :  09:03:52  Show Profile  Reply with Quote
I recently had the same issue moving large files on Windows Server 2003.

I used 2 methods

Scripting option: Check out XCOPY with /Z /J options

GUI option: I've been using Teracopy for this.



Kindest Regards
AJ
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2079 Posts

Posted - 05/17/2013 :  01:51:46  Show Profile  Visit jackv's Homepage  Reply with Quote
On a nightly job I run i.e copying a 120 GB backup copy - when the server was unnswe menmory pressure - this problem used to occur occassionally. As a workaround - we needed to reboot the server. After a awhile - we doscovered a memory leak on the server.
Instead of now using COPY or XCOPY - which are buffer based , I use a utility called ESEUTIL - which I picked up from Microsoft Exchange and is used to copy large mailboxes within Exchange.
ESEUTIL used unbuffered IO - and has has halved the amount of time . Using it is very simple. Read some notes on usage http://www.sqlserver-dba.com/2011/02/speed-up-copying-large-files-with-eseutil.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000