Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reemjacob
Starting Member
6 Posts |
 Posted - 2003-07-11 : 04:34:23
|
| HiUsing 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 errorError 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 solutionReem |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-11 : 12:24:48
|
| Run this in Query Analyzer:DROP DATABASE DBNameGoesHereChange DBNameGoesHere to the name of the database that you want to delete. If that doesn't work, run this:EXEC sp_detach_db 'pubs', 'true'Change pubs to the name of the database that you want to delete (do not remove the single quotes).If you continue to get an error message with the restores, just post the error here because we might be able to help. If the backup is bad, then you will have to use an older backup.Tara |
 |
|
|
|
|
|
Error 927 Database test cannot be opened