That would be me I guess ;-)...

I guess the embarrassment depends on the difficulty of question?

You can't get away by answering basic questions wrong. Also, depends on the role that you are applying for. I would...

Was this cluster tested thoroughly before SQL server was installed on it?

Also, did you if it was a side by side upgrade, did you failover the nodes after installing SQL...

As Gail suggested Drop the clustered index on 'tblTime' and recreate it.

Then run the checkdb statement again.

snu155 (1/14/2010)

---

you comment on Simple mode, and then you talk about bulk logged mode......

kinda like yelling at spock and punching kirk

Go to bulk logged, i'm fine with that

Go to simple...

You still haven't answered my original question..how did you arrive at the conclusion that there will be a 24 hours data loss..??

Did you try reading this article. It might actually help in your case I see there is a high value for single page allocator from what you have posted.

Try to get a new full backup of this database and then try the restore. If it errors again, then you might as well run DBCC Checkdb on you source...

If you intend to provide HA to your principal database then I would like to say that Replication is NOT a HA solution. It is used to reduce the overhead...

Did you have the table names specified explicitly in your maintenance plan job?

Why would the data loss...

Depends on how the data is being retrieved from the table. Check the execution plan of any of your queries and see if it makes any difference by adding an...

Ali_SQLDBA (1/14/2010)

---

The above query on my deleted table is givng this message as expected

"Msg 2501, Level 16, State...

Ali_SQLDBA (1/14/2010)

---

Thanks for your early reply.

do...

Can you tell us the fragmentation level on this table..

post the results for the below query on your table

dbcc showcontig('table_name') with fast

With so many DML's I suppose you are better...