Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2002
    Location
    Switzerland
    Posts
    4

    Angry Unanswered: SQL Server 7 SP3

    I'm trying to install MS SQL 7 Service Pack 3.

    I receive the following message: One or more of your databases have been marked as read only, offline, or suspect (not recovered). Correct the problem and try again.

    Can anyone give me the procedure to follow to correct the problem ?

    ThanX

    Christophe

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Are any of the databases read only, offline, or suspect?

  3. #3
    Join Date
    Jan 2002
    Location
    Switzerland
    Posts
    4
    Originally posted by nigelrivett
    Are any of the databases read only, offline, or suspect?
    Hello,

    I checked my own database (I have only one) and the system databases with the stored procedure sp_dboptions and no databases have such a flag set.


    I found in the Microsoft site that it is a bug. See Q294753.

    Do you have any idea how walk through that problem ?

  4. #4
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    That is saying that if any database is Read-only, Suspect, or Standby then you will get the message. You have checked your databases and say this is not so.

    Did you restart the m/c before trying to load the service pack?
    Are you sure that you are using sa for the upgrade?
    Try logging on using the sa password you gave and creating a table in each of the databases to check that they are updatable.
    Model is a database that could have problems and you wouldn't notice.

  5. #5
    Join Date
    Jan 2002
    Location
    Switzerland
    Posts
    4

    Thumbs up

    Hello nigelrivett,

    Your suggestion to create a table in each database was good. I created a simple table in each database and immediately delete it. The creation was ok for each database.

    After that I shutdown SQLServer and SQLServerAgent and installed the SP3 with no problem.

    I can't explain why it worked but it worked.

    ThanX

  6. #6
    Join Date
    Feb 2002
    Posts
    1
    It's nothing like the good old MySQL

  7. #7
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    I'm sorry GraphicW, I think you may be in the wrong forum. This MS SQL Server not MySQL.

    You know when I see comments like that I always remember this car ad on TV. The one were this car manufacture compares itself to BMW and Mercedes, saying it has all the features and performance but for a lot cheaper. However have you ever noticed how BMW and Mercedes never compare themselves with other cars or mention other manufactures? When you deliver the best you don't compare with subquality cars.

  8. #8
    Join Date
    Feb 2002
    Location
    Cincinnati
    Posts
    4
    Have you tried reseting the database status?

Posting Permissions

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