Depending on budget one option is a more dedicated backup tool like mozy pro which knows how to set up the vss snapshots for services like sql server. See http://support.mozy.com/docs/en-user-pro-win/guide/concepts/client_config_vss_c.html
I've heard good things about its support of fiddlier systems like exchange, and they handle the mundane problems of backup data storage. I think configuring vss is bit of a black art... mick On Mon, Mar 9, 2009 at 15:32, Daniel Kersten <[email protected]> wrote: > > Hi all, > > Apologies for the completely not Python related question :-D > > I generally use Linux when it comes to anything besides entertainment, > so haven't a clue when it comes to Windows. > What would be the best way to backup a number of files from a windows > machine at regular intervals? > The items I want to back up are: an MS SQL database, some registry > keys and some normal files. > > Some of these files may be locked due to being in use when the backup > process takes place, so I assume I have to use the Volume Snapshot > Service stuff to be able to read these files.. > > I was planning on something like this, from a batch script: > 1. Use vssadmin to create a shadow copy of what I want to back up. > 2. Use the cygwin version of rsync (or something similar, eg: > robocopy) to do the actual backup > 3. Extract and backup the registry keys (somehow, don't know how yet) > 4. Rsync the database file directly (rather than backing up only the > required content.. because I don't know how - its an MS SQL version > thats embedded in third party software...) > 5. Use vssadmin to remove the shadow copy again > > Then run this script from the task scheduler. > > The only thing is, I'm not really sure how. I don't know a thing about > batch scripts and have no idea how to extract registry keys. > > Anyone got any ideas? > > THANKS! > Dan. > > -- > Daniel Kersten. > Leveraging dynamic paradigms since the synergies of 1985. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Python Ireland" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.ie/group/pythonireland?hl=en -~----------~----~----~----~------~----~------~--~---
