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

• asco5

  Say Hey Kid

  Points: 665

  More actions

  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

• naga.rohitkumar

  SSCertifiable

  Points: 5738

  More actions

  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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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

• asco5

  Say Hey Kid

  Points: 665

  More actions

  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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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

• jnuqui

  SSCommitted

  Points: 1585

  More actions

  June 6, 2013 at 5:34 am

  #1621675

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

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

  "lets do amazing" our company motto..