MS SQL Server - Re: Enterprise Manager Databases

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Enterprise Manager Databases

KZeeh

2005-03-31, 8:01 pm

OK, but how do I determine if a database is offline? I don't know where to
see that. Thanks.

"Daniel@tamc" wrote:
[color=darkred]
> This the response I got from TheMuffinMan:
> Yes, Daniel....what happens is you have an offline database and it somehow
> got the ID changed on it. You can make it "Online", or remove it via
> query....or run an update on the sysdatabases table. I forgot the exact
> command, so let me try to find it. Until then, try to run with the above and
> let me know.
>
> I used Query Analyzer to delete the offline databases, then everything came
> back.
> Hope that helps,
> -Daniel
>
> "KZeeh" wrote:
>

Sponsored Links