Post reply

Error 927 Database test cannot be opened

  • July 11, 2003 at 2:43 am

    #59467

    Hi

    Using Enterprise Manager I tried to restore a database from backup. The restore failed and the database is shown in gray color.

    I am trying to delete the DB, to recreate it again But I am getting an error

    Error 927 Database TEST cannot be opened. It is in the midlle of a restore.

    What should I do to rectify this. Looking forward to a solution

    Reem

  • July 11, 2003 at 3:42 am

    #465024

    hi,

    just do the restore again with force restore over existing database, rather then removing it forst

    Paul

  • July 11, 2003 at 8:49 am

    #465098

    You can not force a restore over a restoring database. You must use sp_dbremove or sp_detach_db.

    Shas3

  • July 14, 2003 at 2:40 am

    #465260

    Hi,

    I think what you may have done is to Restore the database with the 'Leave database read-only and able to restore additional transaction logs' option selected.

    This mode allows you to restore log file backups so that things like upto point-in-time recoveries are possible. (A traditional backup plan would comprise, for example, a daily complete or differential backup with an hourly log backup.)

    If this is the case you can restore the database using theT-SQL command:

    RESTORE DATABASE MyDb WITH RECOVERY

    See 'Recovering a Database Without Restoring' in Books online for more details.

    -Ed

  • July 14, 2003 at 12:20 pm

    #465408

    Hi

    As per Paul, the force restore worked. Thanks guys for helping.

    Reem

Viewing 5 posts - 1 through 4 (of 4 total)

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