Set the DB to simple recovery mode, like all the others, then do a once-off shrink of the log (just the log) if it's larger than it's supposed to be....

no_log is deprecated in SQL 2005 and not recommended for use. If log backups are not required, then just switch...

ltoso (7/8/2008)

---

Hi,

thanx for the fast reply, i am very new to sql server so can you help me further like

What is the recovery model for this database?

where can check this...

Leave off the triggers. consider cascading deletes on your foreign key relationships.

I spoke with the South African MVP lead back in March on this topic. He said that in his opinion (not an official MS statement) the most important quality is...

Try this.

DECLARE @TheDate DATETIME

SET @TheDate = '1994-08-01 00:13:00.000'

select dateadd(dd, datediff(dd,0, @TheDate),0)

Is it consistent? Did the data have to be fetched from disk on one? Possible blocking?

What I suspect is happening is that the cluster service notices that SQL is not responding (IsAlive Check) when SQL hits memory problems and forces a fail-over to the other...

Graham (7/8/2008)

---

Hi Gail

Thanks for your reply, i appreciate it, will get back to this thread tomorrow when the office is open.

Yes i saw the full scans are pretty high, does...

Don't! Shrink! Your! Databases!

tucankur: Have you checked for hardware errors? Reoccuring corruption can indicate a storage...

It is not normal to have 10 deadlocks a...

Or just set the database into single user mode with rollback_immediate

Mani Singh (7/8/2008)

if you see a deadlock that is in place for a long time, make sure, it is not running a HUGE Query.. then kill the SPID associated with...

And you see the one from reporting services with duration = 60 sec?

Can you perhaps post the query?

Index placement depends on what queries you have running and what your data distribution looks like. To put it very simply, you create indexes to support queries that you have...