Jump to content
Sign in to follow this  
Bonthron

Backing up a remote SQL server remotely from Mac Retrospect?

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×