I have inherited a problem that I am hoping someone can help out with. A developer used a perl script to move some backup files from one server to another and then restore the databases on other server (at least we think that is what happened, no one is really sure at this point)

Now I need to take the databases ourt of read only mode and drop them but I get an error 5063 stating that the database is in warm standby and the alter database and sp_dboption statements both fail.

How do I get the databases out of warm standby mode?

Thanks in advance for any help you all can provide.

Brad