HOBOCOPY ROCKS!!!

I just took a live snapshot of master, model,msdb and distmdl. Eh, not to big a deal as is, but still. I don't need to go thru whole backup and restore to create a standby. Just move the these files and start the other server. presto, and of course move/backup/restore all your other DBs.

SHARING IS CARING!


C:\Documents and Settings\bobmihada>hobocopy E:\mssql2k5\MSSQL.1\MSSQL\DA
TA E:\mssql2k5\MSSQL.1\MSSQL\DATA2
HoboCopy (c) 2006 Wangdera Corporation. hobocopy@wangdera.com

Starting a full copy from E:\mssql2k5\MSSQL.1\MSSQL\DATA to E:\mssql2k5\MSSQL.1\
MSSQL\DATA2
Copied directory
Backup successfully completed.
Backup started at 2010-02-27 01:09:24, completed at 2010-02-27 01:11:21.
12 files (733.75 MB, 1 directories) copied, 0 files skipped

C:\Documents and Settings\bobmihada>

Restoring the master is such a pain.

~see you work the body

Comments :