Command Line : Snapshot Automation

jamesforestjamesforest Posts: 2
edited November 24, 2011 1:06PM in SQL Compare Previous Versions
I am considering automating the generation of snapshots on a periodic basis via the command line. I was hoping to create new snapshot datasets with a timestamp suffix versus using the /force parameter. Any provisions for this now or in the future?

Comments

  • Thanks for your post.

    There's a "makesnapshot" switch for the command line (see the list of switches here) which may help.

    There's no option to automate the filename to a date/time etc, but if you are combining it with an MS-Dos batch file you could probably use variables to perhaps name the file based on the current date? For example, someone had a similar query (unrelated to RedGate products!) here - could be worth checking out.

    You can use Windows task scheduler to kick it off.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.