Click to See Complete Forum and Search --> : Remote Database Backup


cristane
June 16th, 2006, 03:15 AM
Hi everyone

Do you have any idea how I can make a backup for a remote database? (preferrably using a command in the command line, or with a stored procedure...)

I hope the question isn't too silly, but I haven't found a clear answer for this problem yet.

Thank you.

jp140768
June 26th, 2006, 07:16 PM
What database are you using? With SQL Server, you can run the backup as a scheduled job. With Oracle, we use the EXP command via a DOS file. With MS Access, you backup the MDB file, don't think you can script that one.

Not sure with other databases.

HTH