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.
Enjoy!
-Kev
Twitter @kekline
Tags: SQLMag, Tools, Tools & Scripts





















Well now you’ve gone and done it
Now I’m going to be tagging you in all my posts and even worse….. wait for it…… wait for it…..
Can you virtually present for EDMPASS on February 24th?
Hi Kevin –
I’ve been using the nifty (and free) Microsoft PowerToy ‘SyncToy’ (now at v2.0) for automating the unpleasant but necessary task of backing up various files and it’s been working great.