Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2003
    Posts
    232

    Question Unanswered:

    How much time does a 20 g tape backup take to recovery
    I am on 6.5 sql and have compacq 15/30 gb DLT

    How best to configure a standby sqk 2000 server

    salim
    __________________
    Last edited by sjumma; 07-28-04 at 12:40.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    With restore you can either contact Compaq (now HP, and that is if HP still supports it) or experiment yourself.

    As for warm standby, you have only 1 option considering you're still on 6.5, - backup and restore. I would not recommend neither clustering nor replication for that version. None of them really worked for you to really rely on them unless you are committed enough to be ready to troubleshoot it almost daily.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I didn't have much luck with clustering, but replication worked nicely for me in MS-SQL 6.5. Log shipping wasn't officially supported by Microsoft, but it worked reasonably well too.

    -PatP

  4. #4
    Join Date
    Oct 2003
    Posts
    232

    Arrow

    warm standby is on 2000 sql server that i am soon upgrading tooo

    how best to configure it

    we have about 20 users reading and writing on a 20 gb database


    for 6.5 i just do a transfer every sunday takes about 6 hrs
    Last edited by sjumma; 07-28-04 at 12:55.
    bigfoots

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Quote Originally Posted by Pat Phelan
    I didn't have much luck with clustering, but replication worked nicely for me in MS-SQL 6.5. Log shipping wasn't officially supported by Microsoft, but it worked reasonably well too.

    -PatP
    You can't call it "Log Shipping" in 6.5 because you had to write it yourself, which is why I called it just backup and restore. And replication? Have you tried Merge in 6.5? Or, as I used to refer to it as "Merge THIS, #$%#$^ &*%$@#!!!!!" when I had to remove it, and redo it again while users were screaming you know what at me.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  6. #6
    Join Date
    Oct 2003
    Posts
    232

    Arrow

    warm standby is on 2000 sql server that i am soon upgrading tooo

    how best to configure it

    we have about 20 users reading and writing on a 20 gb database


    for 6.5 i just do a transfer every sunday takes about 6 hrs
    __________________
    bigfoots

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I would probably just use DTS to keep the standby warm, although you could probably do it using snapshots too if you were willing to tinker with it long enough. I'd set up a "private" IP connection between the old and the new server, something like:
    Code:
                             +------------+      <== Private
                             |            |
    +---------------+    +---+---+    +---+---+
    |  Workstation  |    |  Old  |    |  New  |
    +-------+-------+    +---+---+    +---+---+
            |                |            |
            +----------------+------------+      <== Public
    Use only the IP addresses on the private network, NOT the DNS names. Schedule DTS task(s) to copy the necessary data to the new machine.

    -PatP

  8. #8
    Join Date
    Oct 2003
    Posts
    232

    Arrow

    Can you be more detailed

    Schedule DTS task(s) to copy the necessary data to the new machine.


    how will that work to do whole database or can i just copy the changes????


    how is it different from publisher and subscriber


    sorry for ignorance

    and thanks
    bigfoots

  9. #9
    Join Date
    Oct 2003
    Posts
    232

    Arrow

    i have to do hotbackup on 2 ,2000 sql server

    so that anytime i have 2 sql server; we just write to one server and other as live backup


    whats the best strategy ??
    bigfoots

Posting Permissions

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