THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

The Awesomeness of ROBOCOPY Now at SQLMag

If you're like me, you've used Ctrl+C/Ctrl+V more than a time or two, but you've always felt a little dirty afterwards.  Yeah, you can use the command-line COPY or XCOPY utilities.  But they're decidedly 20th Century, much like some of the laundry still loitering under my office couch.

So I spent a little time over the holidays cleaning up my file system by scripting a backup routine using the very cool and very free ROBOCOPY utility.  Now, I've got a regularly scheduled job that, after the first run which captured all my files, only backs up new or changed files (and directories) while keeping all of their NTFS attributes.  Boo-Yah!

Read all about it on my Tool Time Blog at SQLMag. I'll also show you how to use some other free and powerful alternatives in future entries.



 Twitter @kekline

Published Tuesday, January 12, 2010 9:22 PM by KKline
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Ewan said:

January 13, 2010 4:30 AM

KKline said:

Foiled again, Ewan!  And I would've succeeded too if it weren't for you teenagers and your dog!

You saw through my clever ploy.  I plan on writing about SyncToy very soon.  Drat!  



January 13, 2010 10:04 AM

RobL said:

Instead of Robocopy, use RoboCopyPlus ( It is a wrapper around your instalaltion of Robocopy, that adds email notification depending on teh job result (success, warning, error) and optionally attaches logfiles that it can strip down to showing the warnings and errors only.

Cool little tool :)!

March 15, 2010 6:17 PM

Leave a Comment


About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS,

This Blog



Privacy Statement