Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: backup and restore

    I have a database xxxx on server a, I want to copy this DB to server b.How can I do this By back and restore.
    WHere can take this back up?I want to take this to a personal folder and wanted to restore to server b from this folder.Is it possible?
    Thanks.

  2. #2
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    On server a:
    backup database xxx to disk = '\\b\sharename\xxx.bak' with init

    and then on server b:
    restore database xxx from disk = 'd:\sharename\xxx.bak' with replace,
    move 'xxx_data' to 'e:\xxx_data.mdf',
    move 'xxx_log' to 'f:\xxx_log.ldf'

  3. #3
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    You can backup to a network location, then have a seperate job run the restore using that location. See backup [described] in BOL.

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •