What are the challenges you face when working across database platforms? Take the survey
Options

REG: Backup from production database to local database

RageshRagesh Posts: 2
edited November 25, 2009 5:45AM in SQL Backup Previous Versions
Hi,
Is it possible to backup a database from production DB server to local DB server using the Sql Backup 6. I want to know how the schedule the job to take a weekly backup. I just download the 14 days trial version. Please let me know the above mentioned things are possible or not?

Comments

  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    Hi

    Thank you for your post into the forum.

    Yes it is possible to backup a database on a production server and restore the backup file on another server. Both databases will require that the SQL Backup Servers components are installed upon them.

    Use either the 'Backup' wizard or if you wish to schedule a backup use the 'Schedule Backup Job' wizard on the production machine to the create the job or the backup file.

    To restore the backup file created on the other machine, run the 'Restore' wizard to restore the file.

    This link is to the SQL Backup help information on the Red Gate web site:
    SQL Backup Help.

    You will find various help information, demos and walkthroughs on how to use SQL Backup.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.