GENiALi's Blog

inDE Original

0TweetsRetweet

The hard drives are filled on a SQL 2000 Server.
Some databases have been set to read-only.

If you wanted to remove the flag in the database options
came following message.

Error 5063: Database 'model' in in warm standby.

There were quite a few other databases that had this status.

First place was created of course so the server again
does as it should. Then all databases should again from the
read-only mode will be brought. This was but not so easy.

This error message again came. After a restart
the server's were the same databases still in the 'read only'
Status. What do?

By chance I noticed that a detach and attach the database
the problem solved. I don't know whether it is correct. In the Internet
you repeatedly following tip.

restore log with recovery < database >

I wanted to do but not really on a production database.
To do so I missed the experience simply. Neither the detach and attach
I myself but to make.

But database I brought the model so from a State out.
Who could I not detaching. But here helped after the restart of the server's
the following command in Query Analyzer.

use master
restore log model with recovery

Schoen 'model' database is now back in the proper state. :-)