Hello Gilamonster,

I ran DBCC Checkdb as below:

DBCC CHECKDB (PTPortal) WITH NO_INFOMSGS, ALL_ERRORMSGS;

And got below error message:

Server: Msg 8937, Level 16, State 1, Line 1

Table error: Object ID 901578250, index ID...

Just googled error message and found this issue occurs because the SHRINK operation cannot remove a page from the SYSFILES1 system table on the primary data file of the database....

Thanks a lot GilaMonster and Joe !

I just checked with client end, and found they are ok with the performance of sql server but... they got one error while performing...

Ohh.. Is there any way to know how much data lost? Or how to find what table affected by that ?

DBCC Checkdb completed after long time of about 3 hours...!!! There are 0 allocation error but have seen some consistency errors.. :crazy: Below is the message that i receive...

Hi Bhuvnesh,

I am not sure about it...! I m just guessing and asking if disk shortage can cause torn page. Moreover, its sql server 2000, what may be the solution...

Thanks Jason ! I did changes in max memory, lower down 30GB Max memory to 28GB. and yes without restart it release some memory. Before it was consuming 31.7GB out...

Is it dynamic change ? I mean if I will lower down the max memory, Will SQL server will release memory...

Thanks a lot Arjun !

You explain me what exactly statisc is and what the sql server doing during update statics. Can you pls clear my more doubts?

1. Is it using...

Thanks Anthony, Penny and Rama.

@Penny: there are two instances.

I think i got the lesson that I am working on Failover cluster where sql services are stopped on one server and...

Hi Raheel,

You can use both the node either physical or both of them virtual, its upon you. But to save hardware cost you can go with Virtulisation.

Hello Saket,

just for my knowledge,

What does that status means ?

Status 66057

Status2 1627389952

From where I can check the meaning of this status ?

Yes it will make my db online.

But I want to know reason why it was offline.

Using

Select * from sys.databases

I came to know that is_auto_close_on is set to 1 (True) that means it will try to get up automatically right ?

but unfortunately it was...

The status of DB is

Status Status2

66057 1627389952

now where to check what this status does mean ?

There is same thing in Eventlog...