Post reply

[SQL Server 2008 R2] System Databases lost after migration

  • June 24, 2012 at 10:16 am

    #263136

    Hello,

    I virtualized with Hyper V MS Server 2008 R2 Enterprise and SQL Server 2008 R2 Enterprise.

    Then I attached for test purposes two older 'SQL 2000 mdfs and its log files.

    As recommended from Microsoft, I checked the consistency of the attached databases under SQL 2008 R2.

    So, I scripted the following:

    DBCC CHECKDB ('DB-1').

    MS SQL Server reported an inconsistence in a table, which I tried to repair via

    DBCC UPDATEUSAGE ('DB-1').

    I ran one more time CHECKDB over the entire db, resulting in 0 errors, now.

    But then I noticed, that the system databases are lost !?

    Is there a certified method of how to restore the system databases !?

    I tried this:

    Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName /SQLSYSADMINACCOUNTS=accounts [ /SAPWD= StrongPassword ] [ /SQLCOLLATION=CollationName]

    Though I must say, the result was not satisfying. ;(

    Maybe, one of you gurus does have another idea to restore the system databases (without re-attaching the SQL2000 databases) ?

    Thank you, in advance,

    Stephan

  • June 24, 2012 at 11:01 am

    #1504833

    Define 'lost'

    What is the exact state of the SQL instance?

    What did you do to the system databases? (neither checkDB nor updateusage will affect any database other than the one they are run against)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 24, 2012 at 11:26 pm

    This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

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