locked
Snapshot is not usuable after in-place upgrade RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I run an in place upgrade from SQL 2008 to SQL 2012 + CU8 and now I can't open all my snapshots. why?

    how can I read this snapshot ?

    the error I get in the SQL Error log right after the upgrade is:

    Message
    Database 'SnapshotDBName' cannot be upgraded because it is read-only, has read-only files or the user does not have permissions to modify some of the files. Make the database or files writeable, and rerun recovery.

    and when trying to use the snapshot DB, I get this error:

    Msg 926, Level 14, State 5, Line 1

    Database 'SnapshotDBName' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

    • Moved by Tom Phillips Tuesday, January 28, 2014 1:26 PM Probably better upgrade question
    Tuesday, January 28, 2014 1:21 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    During upgrade changes are made how would you expect upgrade process to make change in DB shanpshot which is read only.So you got this message.

    Is is not possible for you to create napshot again.

    Please see solutions provided in below link

    http://support.microsoft.com/kb/2710782/en-gb

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Alberto MorilloMVP Tuesday, January 28, 2014 5:38 PM
    • Marked as answer by tracycai Tuesday, February 4, 2014 2:17 AM
    Tuesday, January 28, 2014 4:09 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    During upgrade changes are made how would you expect upgrade process to make change in DB shanpshot which is read only.So you got this message.

    Is is not possible for you to create napshot again.

    Please see solutions provided in below link

    http://support.microsoft.com/kb/2710782/en-gb

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Alberto MorilloMVP Tuesday, January 28, 2014 5:38 PM
    • Marked as answer by tracycai Tuesday, February 4, 2014 2:17 AM
    Tuesday, January 28, 2014 4:09 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    Do you noticed if the disk drive was running out of space during the upgrade process? SQL Server uses a few gigabytes from disk during the upgrade.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, January 28, 2014 4:30 PM