Post reply

Please help i have a big probleme my database is empty and i need to go back!

  • June 6, 2013 at 4:11 am

    #294909

    Hi everyone

    this morning i start my database and everything is gone inside

    all my tables are empty

    i have no backup

    is there any way i can restore it as it was the day before?

    please help

  • June 6, 2013 at 4:27 am

    #1621663

    HI ,

    1.pleasse verify the path of the backup location reside

    if available u may restore

    if not

    2. in every company windows [wintel team ] may take the whole server and its backup of all drives in the tape so try to restore form that and u will get the backup file[ bak ] of the database and then try to restore u will get ur data back

    Thanks
    Naga.Rohitkumar

  • June 6, 2013 at 4:34 am

    #1621665

    What do you mean, the database is empty? Someone ran a script dropping all tables?

    Production server or local test DB?

    Without a backup, there's no way to restore a database to a previous state.

    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 6, 2013 at 5:00 am

    #1621669

    GilaMonster (6/6/2013)

    What do you mean, the database is empty? Someone ran a script dropping all tables?

    Production server or local test DB?

    Without a backup, there's no way to restore a database to a previous state.

    It's a test server

    i think yes someone run a sql request with drop table things like that but im not sure

    but everything is empty now

    and i have no backup

  • June 6, 2013 at 5:19 am

    #1621671

    asco5 (6/6/2013)

    i think yes someone run a sql request with drop table things like that but im not sure

    but everything is empty now

    and i have no backup

    Then I guess you'll be spending the next few hours recreating the tables as they should be, investigating who ran the drop table script and afterwards sorting out a backup strategy.

    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 6, 2013 at 5:34 am

    #1621675

    No backup = No way of retrieving those deleted data back.

    ===============================================================

    "lets do amazing" our company motto..

Viewing 6 posts - 1 through 5 (of 5 total)

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