Maintenance plan is the wrong tool for this. It rebuilds all the indexes regardless of the fragmentation.

This works about 200 times faster on my servers (after a few runs)...

Either is fine. I just think full is overkill in...

yes you can force a checkpoint if you want but it runs by itself on a regular basis...

sure. Why don't you do what you want??

Stefan Krzywicki (7/14/2011)

---

Because it is likely that at some point in...

Then why waste the ressources on the logs? Just move to simple if you don't need PIT recovery.

CheckDB reads all used pages. So if that works then you're good.

The only thing left is to check all the backups (fulls, diffs, logs).

And NO verify only is not...

SQLkiwi (7/14/2011)

---

I thought so too, though I can't find the previous question. So, an easy 'green tick' for me today,...

SanDroid (7/14/2011)

---

Got it wrong because my experiance and M$ docs aparently do not match with that of the rest of the world. 😛 Maybe I should start including...

http://www.yohz.com/products_sqlverify_restoreverifyonly.htm?source=ssc

I actually go 2 up from that.

I test the logs as well.

I do full backup and do test restore + checkdb. But then twice a day I do a...

---- Get Total Count

SELECT Count(''x'') FROM [dbo].[PaymentView] a (nolock)

should be

---- Get Total Count

SELECT Count('x') FROM [dbo].[PaymentView] a (nolock)

Been there, done that...

Done!

I'd like your opinion on this one (2nd post) :

http://www.sqlservercentral.com/Forums/FindPost1141659.aspx