SQL Server Performance

backup and restore to another server

Discussion in 'Getting Started' started by nirukonda, May 15, 2007.

  1. nirukonda New Member

    Hi Folks,


    I need to take back up of a database from server A and resotre the backup to serverB.

    How can this be done?
    Please provide me proper steps to carry out this activity as it is a cluster environment.


    How can a backup be copied from one server to another both in sql 2000/2005?




  2. MohammedU New Member

    Just run the backup using QA OR EM on source serverA.
    Backup database <dbname> to disk = '\servernamec$dbname.bak'
    with init, stats = 10

    Run the restore command using QA or EM on Destination ServerB.

    Restore database <dbname> from disk '\servernamec$dbname.bak'
    with recovery, replace,
    move 'Datafile Logical filename' to 'Phisical filename and path',
    move 'LogFile Logical filename' to 'Phisical filename and path'

    Check BOL for complete syntax...

    You can restore the backup of sql 2000 on to sql 2005 and backup restore method is the same in 2000 and 2005 and there is no difference when you are running backup or restore on cluster...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page