Error 927 Database test cannot be opened

• reemjacob

  SSC Veteran

  Points: 208

  More actions

  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

• paul_richardson

  SSCarpal Tunnel

  Points: 4594

  More actions

  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

• Shas3

  Hall of Fame

  Points: 3671

  More actions

  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

• EdH334

  SSCrazy

  Points: 2857

  More actions

  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

• reemjacob

  SSC Veteran

  Points: 208

  More actions

  July 14, 2003 at 12:20 pm

  #465408

  Hi

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

  Reem