Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2004
    Posts
    1

    Unhappy Unanswered: Backup ODBC on Windows 2000 Server?

    howto backup ODBC configure and data on windows 2000 server help me!
    thanks.

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    urr?
    Are you wanting to backup SQL Server?
    Are you wanting to backup any data that you can find an ODBC driver for (that would be fun)?
    Are you wanting to confuse me?
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you want to backup the ODBC configuration of the server, including its ODBC drivers, DSNs, FSNs, etc, make a full backup of the whole server. Although it is possible to "clone" the ODBC configuration onto a new server, that is not a wise idea.

    -PatP

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    ODBC configuration is kept in registry which is what you need to back up.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by rdjabarov
    ODBC configuration is kept in registry which is what you need to back up.
    Yes, and restoring a registry onto another machine has always been a reciepe for disaster in my book. Even doing selected hives or even keys is dangerous unless the destination machine has EVERYTHING referenced in the source machine!

    -PatP

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    OK, who pissed Pat off???? Raise your hand!
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Sorry if I sound testy, I certainly didn't mean that. The problem with telling someone that isn't very familiar with the registry to do much of anything with it, is that there is huge risk.

    Based on the question, my guess is that they aren't familiar with the even what the registry is, much less how to work on it. If they wipe out a hive (yes, I've seen that done!), they can make a machine unbootable. That's pretty risky stuff, just to save 5 minutes of ODBC setup.

    Even if they just have the wrong MDAC or Oracle version, that can make it useless to restore the DSNs from one machine to another. I guess that I've had to fix too many machines where someone was trying to save five minutes and it cost me a day of travel and three hours worth of work.

    -PatP

Posting Permissions

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