Post reply

Upgrade SQLSERVER from 8.00.194 to 8.00.818

  • May 9, 2006 at 7:06 am

    #366106

    Hi guys,

              I have a sqlserver instance created with version 8.00.194. I brought a database from another box which was at version 8.00.818. We have done inserts and updates on this database. Realized the mistake and would like to patch it to version 8.00.818.

    Question: Is it ok to upgrade ie patch when the database is 8.00.194 and the actual ie master is at 8.00.194?

    Any help would be highly appriciated.

     

    Nirmal

  • May 10, 2006 at 10:08 am

    #637045

    I really do not think you will have a problem in this situation..  have done this before. if there is a high level of concern, I would contact MS just to be sure.

  • May 10, 2006 at 3:15 pm

    #637120

    It appears that you are runnjing SQL 2000 RTM (the initial release) and you want to go to SQL 200o SP3a plus hotfix 818. First off, you cannot patch (upgrade to a SP/hotfix) an individual database, it is done by database server/server instance. On another note ... I did not know it was possible to load a 'newer' version of a user database into an 'older' version of SQL server ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • May 10, 2006 at 3:37 pm

    #637123

    i didn't think actual database backups were labeled with a version... i thought only the server had an @@version, and the data was always backed up to an 8.00 version, so any 8 or above system would restore it.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 10, 2006 at 3:59 pm

    #637128

    Lowell, I know for sure that the database backup is 'versioned' for the master database (I haven't tried msdb or model) ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply