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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-07-12 : 12:28:59
|
I have a problem with my SQL Server 7 and would appreciate any help/advice. I have a database on their that is no longer required, it is marked as Read Only but when I try to take this flag off I get an error ERROR 15030 The read only bit cannot be turned off because the database is in standby mode I'm sure I had seen this before but now can't find anything helpful at all. Any suggestions would be greatly appreciated.Many thankssteveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-07-12 : 12:58:35
|
| Think I may have just solved it, please ignore my feeble bleatingssteveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-07-12 : 15:52:56
|
| Nope, sorry. Can't forget it, now. It is looking like a challenge. Did you issue restore database (dbname) with recovery to fix it? |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-07-13 : 03:18:52
|
| Yes, well spotted that mancheerssteveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
|
|
|
|
|
|
|
|
Would appreciate any response