Post reply

Cannot open tempdb version 0.

  • February 27, 2007 at 12:56 pm

    #177033

    I download SQL Server 2005 SP2 and applied to my SQL Server 2005.

    Run into issues "Cannot open database 'tempdb' version 0.  Upgrade the database to the latest version (Microsoft SQL Server, Error:946).

    Have anyone seen this problem?

    Thank you.

    Edwin

  • February 27, 2007 at 9:42 pm

    #692221

    I have applied to one server but it was successful.

    I have not see this error in forums..

    At what stage in sp2 process you are getting error?

    What is your sp2 installation log file says?

    MohammedU
    Microsoft SQL Server MVP

  • February 28, 2007 at 9:32 am

    #692336

    I applied to two SQL Server 2005.  One of them is working okay.

    The SQL Server 2005 run replication was having issues.

    Where can I find the log file?

    TJ

  • February 28, 2007 at 3:36 pm

    #692454

    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG check summary.txt file and "Files" folder too...

     

     

    MohammedU
    Microsoft SQL Server MVP

  • March 1, 2007 at 8:54 am

    #692640

    I went over the Summary.txt file and I did not see and find any errors.

    So, SP2 installation is okay.   However, the SQL Server 2005 was running replication process. 

    I saw intermittend issues of "Cannot open database 'tempdb' version 0. Upgrade the data to the latest version. (Microsoft SQL Server, Error: 946).

    I bang my head to the wall and try to resolve this issue. 

    How to upgrade the tempdb in SQL Server 2005? I am very new DBA Admin SQL Server.

    Thank you.

    TJ 

  • March 1, 2007 at 9:02 am

    #692644

    Additional error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SQLServer.Rmo)

    Have you seen these errors!!

  • March 2, 2007 at 6:59 am

    #692828

    For databases in replication, multiple servers are involved (publisher, distributer, and subscribers). you need to upgrade the servers in the right order. The SP2 readme has the details.

  • March 2, 2007 at 3:35 pm

    #692944

    Yes, I went to SP2 ReadMe file.  But It won't apply to my case.

    Because my Distributor and Subscribers  are running in SQL Server 2005.

    And my Publisher is running in SQL Server 2000.

    Thank you for your inputs.

     

  • March 2, 2007 at 6:01 pm

    #692953

    Tempdb created using the model db...

    Check your model database cmpt level and run the checkdb against model?

    Lastly open case with PSS OR post the question in MS forums...

     

    MohammedU
    Microsoft SQL Server MVP

  • March 3, 2007 at 3:24 am

    #692978

    I agree with MohammedU I would suggest you to contact PSS.

Viewing 10 posts - 1 through 9 (of 9 total)

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