Bonthron Posted June 16, 2005 Report Share Posted June 16, 2005 We have a small SQL server running on Server 2003 and I need to back it up using Retrospect Backup v 6.0.204 running on a G4 Xserve. Can this be done with the Retrospect Windows Client and the SQL Agent? One of the few things I do know about SQL servers (and I don't know much) is that that you can't back up a running server. Can the server be paused, backed up remotely and then restarted, resulting in a data set that could be recovered from? If yes is there some *easy* scripting function built into Server 2003 that would allow me to pause and restart the server? Thanks for any provided assistance. Quote Link to comment Share on other sites More sharing options...
southcityguy Posted June 17, 2005 Report Share Posted June 17, 2005 I need to do the exact same thing. Can anyone help??? Quote Link to comment Share on other sites More sharing options...
Bonthron Posted June 21, 2005 Author Report Share Posted June 21, 2005 Shameless bump – still hoping for an answer. Quote Link to comment Share on other sites More sharing options...
natew Posted June 28, 2005 Report Share Posted June 28, 2005 Hi This cannot be done with Retrospect for Macintosh. Your only option is to Schedule a windows task that exports the database to a flat file every day. They use Retrospect to backup the exported file. Thanks nate Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.