Subscribe

SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
Speed up copying large files with ESEUTIL - for large file transfer

18 February,2011 by Jack Vamvas

ESEUTIL is the best tool I've used so far - to copy large files across the network for large file transfer. By "large file" I mean at least 50 GB.I found the tool on our Exchange Server installation - where it's used for defragmentation

Normally , if using COPY , Buffered I\O uses Paged Pool - so , if  the file is large the greater chance resources will be consumed - to the point of a COPY failing.

ESEUTIL avoids this process, and uses Unbuffered I\O

Using ESEUTIL I've been able to halve a 95 GB file transfer

The syntax is :

 ESEUTIL /Y \\myserver1\f$\mydb.bak /D  \\myserver2\f$\mydb.bak

Read More

SQL Server DBA Tools

SQL Server test data generation testing tools - SQL Server DBA


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer