After Restore database showing loading?

• andy-232663

  SSChasing Mays

  Points: 603

  More actions

  July 6, 2005 at 6:14 pm

  #114346

  Hello All,

  I restored database from Network drive by UNC,but after restore

  it showing loading for last 2 hour,how can i bring database to normal mode.

  or should i wait it will come automatic to normal mode.

  should i restart server,

  someone told me to use

  sp_resetstatus SP to reset status,but this SP we use only to reset status from suspect status to normal or is it works with loading too.

  Please suggest.

  thanks

• Deni Kusdeni

  Ten Centuries

  Points: 1129

  More actions

  July 6, 2005 at 8:31 pm

  #571623

  You just need to restore the database to became the online status, by running this script :

  restore database (DatabaseName) with recovery

  make sure the all log file has been restore (if you backup your log file)