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 |
|
kbarlon
Starting Member
1 Post |
 Posted - 2007-11-08 : 17:08:32
|
| Loooks like I have a corrupt database. I cannot delete it because "database is used for replication" I am told in an error box . There are no items shown when trying to expand the database. Opening Query anylizer the database is not shown in the dropdown box. If I try to create a database with same name SqL says it is already there. Also the database icon is grey not yellow like the active working databases. Anyone have an Idea of how to get rid of this rogue database. This was a temp entry and no backup was madeThanksKeith |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-11-08 : 17:35:07
|
| Try backing up a small database then restoring it over the problem one. If that works you should be able to drop it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-08 : 17:35:58
|
| Which version of sql? Tried with 'drop database'? You can clean up replication mark with sp_dboption. |
|
|
|
|
|
|
Cannot remove database