Post reply

Database can't be recovered? Any help would be appreciated!!!

  • July 21, 2011 at 8:56 am

    #1356475

    GilaMonster (7/21/2011)

    GilaMonster (7/21/2011)

    What does that CheckDB (with the database name) give you?

    great to have you back Gail!



    My blog

  • July 21, 2011 at 8:56 am

    #1356476

    halifaxdal (7/21/2011)

    Ignacio A. Salom Rangel (7/21/2011)

    Best guess : It's cleanly shutdown + offline + torn page detection which adds up perfectly.

    Thanks for letting us know. Do yuo thing then that the database can still be recovered? Maybe try to bring it online? It will be great if Gail could tell us what the next step should be.

    Now I am definitely confidence that this DB is recoverable, simply because the tool can see the content, right?

    Repeated question from Gail : What does that CheckDB (with the database name) give you?

  • July 21, 2011 at 8:56 am

    #1356478

    halifaxdal (7/21/2011)

    Beside this tool: http://www.sqlrecoverytool.com/sql-data-restore.html

    Do any of you have any other recommendations?

    This tool's company is doing a very good SEO, it's on the top of the search result

    I don't have any actually. I never had to use that sort of tools.

  • July 21, 2011 at 8:59 am

    #1356481

    halifaxdal (7/21/2011)

    Ignacio A. Salom Rangel (7/21/2011)

    Best guess : It's cleanly shutdown + offline + torn page detection which adds up perfectly.

    Thanks for letting us know. Do yuo thing then that the database can still be recovered? Maybe try to bring it online? It will be great if Gail could tell us what the next step should be.

    Now I am definitely confidence that this DB is recoverable, simply because the tool can see the content, right?

    Wrong.

    I've had a DB that a tool like that said it could reclaim data from that was completely and totally unrecoverable, and the tool, when we went and bought it, only returned some of the data. Was a complete 600GB loss.

    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

  • July 21, 2011 at 9:06 am

    #1356488

    Wrong.

    I've had a DB that a tool like that said it could reclaim data from that was completely and totally unrecoverable, and the tool, when we went and bought it, only returned some of the data. Was a complete 600GB loss.

    Then, what do you suggest to do next? In my humble opinion if there is nothing else to do, it will be worth to try the steps in Paul Randal's post, what do you think of that?



    My blog

  • July 21, 2011 at 9:13 am

    #1356495

    Ignacio A. Salom Rangel (7/21/2011)

    Wrong.

    I've had a DB that a tool like that said it could reclaim data from that was completely and totally unrecoverable, and the tool, when we went and bought it, only returned some of the data. Was a complete 600GB loss.

    Then, what do you suggest to do next? In my humble opinion if there is nothing else to do, it will be worth to try the steps in Paul Randal's post, what do you think of that?

    Let me take a stab a this one :

    What does that CheckDB (with the database name) give you?

  • July 21, 2011 at 9:15 am

    #1356499

    Halifax, could you please answer the question, made by Gail and Ninja? Thanks in advance!



    My blog

  • July 21, 2011 at 9:18 am

    #1356506

    Ignacio A. Salom Rangel (7/21/2011)

    Halifax, could you please answer the question, made by Gail and Ninja? Thanks in advance!

    Sorry I thought I already posted.

    I ran

    DBCC CHECKDB('CheckListDB') WITH NO_INFOMSGS, ALL_ERRORMSGS

    I got:

    the Server: Msg 942, Level 14, State 4, Line 1

    Database 'CheckListDB' cannot be opened because it is offline.

  • July 21, 2011 at 9:19 am

    #1356508

    Ninja's_RGR'us (7/21/2011)

    Ignacio A. Salom Rangel (7/21/2011)

    Wrong.

    I've had a DB that a tool like that said it could reclaim data from that was completely and totally unrecoverable, and the tool, when we went and bought it, only returned some of the data. Was a complete 600GB loss.

    Then, what do you suggest to do next? In my humble opinion if there is nothing else to do, it will be worth to try the steps in Paul Randal's post, what do you think of that?

    Let me take a stab a this one :

    What does that CheckDB (with the database name) give you?

    The big font size looks much clearer to me. :-P:-P:-P:-P

  • July 21, 2011 at 9:24 am

    #1356516

    halifaxdal (7/21/2011)

    Ignacio A. Salom Rangel (7/21/2011)

    Halifax, could you please answer the question, made by Gail and Ninja? Thanks in advance!

    Sorry I thought I already posted.

    I ran

    DBCC CHECKDB('CheckListDB') WITH NO_INFOMSGS, ALL_ERRORMSGS

    I got:

    the Server: Msg 942, Level 14, State 4, Line 1

    Database 'CheckListDB' cannot be opened because it is offline.

    I'll shut up now let Gail take <back> over. Too many chiefs and too much noise going on at the moment.

  • July 21, 2011 at 9:31 am

    #1356525

    I'll shut up now let Gail take <back> over. Too many chiefs and too much noise going on at the moment.

    Nobody is a chief, we all want the same and that is help Halifax to recover the database. I must agree with you (Ninja) that Gail is the most qualified person to help haifax, so I'll try not to comment. Good Luck Halifax!



    My blog

  • July 21, 2011 at 9:34 am

    #1356528

    Ignacio A. Salom Rangel (7/21/2011)

    I'll shut up now let Gail take <back> over. Too many chiefs and too much noise going on at the moment.

    Nobody is a chief, we all want the same and that is help Halifax to recover the database. I must agree with you (Ninja) that Gail is the most qualified person to help haifax, so I'll try to not comment. Good Luck Halifax!

    Agreed, but that isn't working for now ;-).

  • July 21, 2011 at 9:36 am

    #1356533

    I want to report to you guys my findings on choosing recovery tools:

    I downloaded two tools, both can only let you VIEW repaired result, the finding is based on trial edition

    1. http://www.sqlrecoverytool.com/sql-data-restore.html

    Recovered 19 tables, table's content is viewable, table's name is no meaningful.

    Recovered 6 SPs, all starts with dt_, not sure if they really belong to the original DB, content doesn't looks all correct because some are empty

    2. http://www.mssqldatabaserecovery.com/submit-download.php

    Recovered 6 tables, all tables name is correct, no content is viewable

    Recovered 6 SPs, all starts with dt_, not sure if they really belong to the original DB, content doesn't looks all correct because some are empty

  • July 21, 2011 at 9:36 am

    #1356534

    Ninja's_RGR'us (7/21/2011)

    Ignacio A. Salom Rangel (7/21/2011)

    I'll shut up now let Gail take <back> over. Too many chiefs and too much noise going on at the moment.

    Nobody is a chief, we all want the same and that is help Halifax to recover the database. I must agree with you (Ninja) that Gail is the most qualified person to help haifax, so I'll try to not comment. Good Luck Halifax!

    Agreed, but that isn't working for now ;-).

    I agree 😉



    My blog

  • July 21, 2011 at 9:37 am

    #1356535

    Ninja's_RGR'us (7/21/2011)

    halifaxdal (7/21/2011)

    Ignacio A. Salom Rangel (7/21/2011)

    Halifax, could you please answer the question, made by Gail and Ninja? Thanks in advance!

    Sorry I thought I already posted.

    I ran

    DBCC CHECKDB('CheckListDB') WITH NO_INFOMSGS, ALL_ERRORMSGS

    I got:

    the Server: Msg 942, Level 14, State 4, Line 1

    Database 'CheckListDB' cannot be opened because it is offline.

    I'll shut up now let Gail take <back> over. Too many chiefs and too much noise going on at the moment.

    C'mon guys, you all rocks

Viewing 15 posts - 106 through 120 (of 130 total)

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