Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2005
    Posts
    5

    Unanswered: Creating Duplicate Databases Daily

    I want to be able to create a duplicate database and update / refresh it daily automatically. This database copy would be used for testing purposes so I don't want it to write back to the original database. Is replication of some kind the answer?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    For a batch process replication is probably overkill. Use either a DTS package or just restore a nightly backup of your production database to your test environment.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by blindman
    For a batch process replication is probably overkill. Use either a DTS package or just restore a nightly backup of your production database to your test environment.

    Did you skip breakfast as well?

    Do a dump and restore
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Nov 2005
    Posts
    5
    I should have said that the Test database is on a different server.
    I have tried doing a Backup via Enterprise Manager and then moving the backup file to new server, but I cannot seem to pick up the file for a restore as only the local databases are shown in the parameters box.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Use the "Restore from device" option and then browse to your backup file. Check Books Online for more assistance restoring databases in Enterprise Manager. The big things you need to watch out for are crossed logins and object ownership between the two databases, are their respective list of users and userIDs are likely not identical.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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