Post reply

Is it possible to recover a MS SQL database (or the whole content) after this was deleted accidentally?

  • July 20, 2015 at 8:58 pm

    #298901

    Hi all,

    our MS SQL Server Administrator deleted / dropped our MS SQL Server database accidentally.

    Is there any form to recover what was deleted? there is no backup of that database (Test environment).

    I would appreciate your answers.

    Regards

  • July 20, 2015 at 11:16 pm

    #1813771

    Most likely, no. This question has been asked many times on SSC and on a few of the threads there were some suggested third party software options. I haven't tried any of them.

    If this was a test system, your other option is to restore from production or QA.

  • July 21, 2015 at 2:59 am

    #1813782

    Fire the DBA , esp since his job is not to accidentally delete / drop the database. Its the one thing he needs to do.

    Test environment can be easily rebuilt using Source code which you developer should have, if he doesn't he should be fired too.

    Restore from prod is a good idea if you don't have compliance issues wot worry about.

    Jayanth Kurup[/url]

  • July 22, 2015 at 1:45 pm

    #1814216

    marizarocio (7/20/2015)

    Hi all,

    our MS SQL Server Administrator deleted / dropped our MS SQL Server database accidentally.

    Is there any form to recover what was deleted? there is no backup of that database (Test environment).

    I would appreciate your answers.

    Regards

    It is unfortunate and depending upon the organizational setup either the DBA or the testing team should own the backup and recovery.

    Coming to your scenario,

    - If this was a virtual machine, ask your system administrators if they have some recent image of the VM which can be restored.

    - Restore from Prod and sanitize the data which is confidential and apply any configuration changes which are required for test environment. You should have these scripts ready in some code repository which can be applied directly after a database refresh from prod.

    - If you must get the same DB back, try for some 3rd party software which can try to recover data and log files but I can't say if recovery will be fullproof.

    I think this as the test environment so you guys are little lucky. Use this opportunity to have a systematic test environment where databases are refreshed atleast once per quarter and any test-env changes may be applied.

    Good luck!!

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

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