Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: duplicating databases

    Ok. Here is what I need to do. I don't even know if it is possible. I have a production server and a db backup server. In a perfect world, I want to be able to place a copy of my databases (users and all) on the backup server and have it update (all changes) regularly.

    I messed with DTS but it errors out because I don't have user accounts set up on the backup server. (I'm not entirely sure it does anything I want to do anyway)

    Can anyone help me find a clue?
    !dbnewb!

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: duplicating databases

    Log Shipping is a good choice for what you want to do.

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    how do i do that

  4. #4
    Join Date
    Feb 2004
    Posts
    1

    cluster it

    Here are some options and explanations. More than likely log shipping will fix your problem...


    http://rjsnetworks.com/rjs/business/clustered4.aspx

Posting Permissions

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