Restoring Database in v8.0

• Viktor Zelenko

  SSC Journeyman

  Points: 91

  More actions

  June 3, 2006 at 12:16 pm

  #366358

  Greetings,

  Please help me to resolve problem with restoring DB in v8.0:

  my backup file is more then 2GB,

  restoration wizard produces successful result, however DB is in 'loading' mode for almost 12 hours.

  Appreciate any suggestions.

  Thanks,

  Vik

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  June 4, 2006 at 9:50 am

  #641591

  If it shows as still loading it sounds like you chose to leave the database in non-operational state in the wizard so the database will not have performed the recovery process as it is in a state where further backups can be applied to it e.g. transaction log backups

  Anyway if the above is the case executing something like swhat below will force it to perform the recovery portion of the retsore operation and bring it on-line

  RESTORE DATABASE MyDatabaseName

     WITH RECOVERY

   

  hth

   

  David