none
Restore crash DBs from SQL2008 R2 cluster to a new server RRS feed

  • Question

  • Dear all,

     

    I need your help in order to restore one of the DBs from the crashed SQL 2008 R2 cluster to a new server.

    Acctually I manage to restore the DB I need to the new server, but at the time I manage to restore it was imposible to restore fully, I have only restore the mdb file do to a inconsystence or maybe corrupted LDF.

    I need to restore the ldf to get to a must current state of the data by the file on the old server or by restoring from SCDPM 2010.

    At the moment of the restore I has lots of errors regarding the DPM restore procedures, but I need to try all sort of procedures in order to restore the rest of lost data.

    Please advice, any help will be really wellcome !!!!!

    Thanks in advance

    Monday, October 17, 2011 6:26 AM

All replies

  • 2011-10-17 00:00:18.99 spid24s     This instance of SQL Server has been using a process ID of 1384 since 12.10.2011 09:03:33 (local) 12.10.2011 07:03:33 (UTC). This is an informational message only; no user action is required.
    2011-10-17 08:39:36.01 spid56      Starting up database 'SP_Content_Workspaces'.
    2011-10-17 08:39:38.79 spid56      Error: 9004, Severity: 23, State: 6.
    2011-10-17 08:39:38.79 spid56      An error occurred while processing the log for database 'SP_Content_Workspaces'.  If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
    2011-10-17 08:39:38.94 spid51      Starting up database 'SP_Content_Workspaces'.
    2011-10-17 08:39:41.72 spid51      Error: 9004, Severity: 23, State: 6.
    2011-10-17 08:39:41.72 spid51      An error occurred while processing the log for database 'SP_Content_Workspaces'.  If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
    

    Dear all,

     

    I need your help in order to restore one of the DBs from the crashed SQL 2008 R2 cluster to a new server.

    Acctually I manage to restore the DB I need to the new server, but at the time I manage to restore it was imposible to restore fully, I have only restore the mdb file do to a inconsystence or maybe corrupted LDF.

    I need to restore the ldf to get to a must current state of the data by the file on the old server or by restoring from SCDPM 2010.

    At the moment of the restore I has lots of errors regarding the DPM restore procedures, but I need to try all sort of procedures in order to restore the rest of lost data.

    Please advice, any help will be really wellcome !!!!!

    Thanks in advance


    Just as an, same details about the current procedures to mo
    unt DB to a new server and the errors I get during the attachment:

     

    Monday, October 17, 2011 6:48 AM
  • Dear all,

     

    I need your help in order to restore one of the DBs from the crashed SQL 2008 R2 cluster to a new server.

    Acctually I manage to restore the DB I need to the new server, but at the time I manage to restore it was imposible to restore fully, I have only restore the mdb file do to a inconsystence or maybe corrupted LDF.

    I need to restore the ldf to get to a must current state of the data by the file on the old server or by restoring from SCDPM 2010.

    At the moment of the restore I has lots of errors regarding the DPM restore procedures, but I need to try all sort of procedures in order to restore the rest of lost data.

    Please advice, any help will be really wellcome !!!!!

    Thanks in advance


    I jzst try to recover from a DPM backup but I'm getting the error you can find on the attached image
    Monday, October 17, 2011 7:37 AM