Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Location
    Long Island NY
    Posts
    4

    Unanswered: Can anyone offer me any suggestions on how to create a back up site w/ db in the even

    I am currently running a site on a shared environment with sql db. The account is with verio.com: Windows Server 2003m SQL 2000.

    What we would like to do is create a back up site with a backup db. I would like this functionality so that in the event of a crash, while the current site is being repaired, or if the server is down for a prolonged period, I can simply switch to the backup site w/ db.

    What would the preferable method of doing this in such an environment? Any help would be greatly appreciated. Thanks.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Look into Log Shipping, sounds like it may answer your needs.

  3. #3
    Join Date
    Dec 2003
    Location
    Long Island NY
    Posts
    4
    I just read up on that at:

    http://www.sql-server-performance.co...g_shipping.asp

    Very interesting...however can I pull that off in a shared environment, even if I have to get a second account?

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    I don't see any issue with LS working in shared environment.
    Can you explain about second account?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Dec 2003
    Location
    Long Island NY
    Posts
    4
    Originally posted by rdjabarov
    Look into Log Shipping, sounds like it may answer your needs.

Posting Permissions

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