Restore database

• Dilip7597

  Grasshopper

  Points: 15

  More actions

  May 14, 2008 at 10:49 pm

  #185598

  i had restore one database "AUTO".

  I processing i had just stopped it.

  and again i want to restore same database but

  it showing "AUTO (Loading)" and i am not able to

  restore it again

• Kevin-458339

  SSCrazy

  Points: 2717

  More actions

  May 14, 2008 at 11:06 pm

  #815632

  Hi

  I have also had a similar scenario - I would try the following:

  * restart SQL Service if you can to see if the status changes

  * does it give you the option to delete database? - i yes then delete and try again

  * can you change the status of the DB - say to offline?

  * try restore a database with same name overwriting the existing

  let us know how it goes

  Thanks

  Kevin