Restoring Database in v8.0

  • 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

  • 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

     

     

     

Viewing 2 posts - 1 through 2 (of 2 total)

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