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

Of course, none of mine have a status of 512, it is a combination of bits.
I've got a lot of 1552's, which I think is 1024(readonly) + 512(offline) +
16(torn page detection). Then I also have a lot of 28s too. I am just not
sure what to "reset" these numbers to. Is there a more comprehensive list
anywhere about resetting the status? Thanks so much for helping me out with
this. I couldn't find any info anywhere on this...

"Daniel@tamc" wrote:
[color=darkred]
> I used query analyzer to query MASTER database, sysdatabases table.
> See this for more info:
> http://msdn.microsoft.com/library/d..._sys-d_5xrn.asp
>
> Status field bits=512 indicates offline.
>
> "KZeeh" wrote:
>

Sponsored Links