Upload the screenshot to a websitre and place the link 🙂

I'll use the GUI tool of TableDiff.exe: http://code.google.com/p/sqltablediff/[/url]

Maybe this could help to remove the error?

But I think if you used the correct parameters, you will receive the same error with...

Can you paste a screen of your maintenance plan?

That was i thinking too , to cover all indexes (1 job for the smallest indexes and 1 for the bigger ones)

But first trying this action 🙂

I will reply if...

I know, that timelimit is not the actual timelimit, but after 2hours (or more), no new reorganize/rebuild will take place...

It's difficult to maintenant a busy system and I'm still testing...

Yes you're right 🙂

I'm busy to change the script to be confirm with the 'standard' names here... (and changing the extention bak to trn to avoid misunderstandings... 🙂

Ninja's_RGR'us (8/8/2011)

---

As I said, I really think you're better off doing that reorg while on site. If people start complaining you can always stop within 5 secs of the...

Ok thanks for the extra info.

Michelle's Index Defrag script is working here, but I use the "@maxPageCount = 3000000" parameter

So the big indexes will be excluded for rebuilding/reorganizing.

EXEC master.dbo.dba_indexDefrag_sp

@timeLimit...

Hey Ninja's_RGR'us,

I'm investigating your script.

As I can understand (I don't have those years experience...):

- Put your code in a job (T-SQL job)

- Stop our transaction log backup job

- Start reorganize...

Ninja's_RGR'us (8/5/2011)

---

Hey Rhox I'd love to do a few tests with your particular case. Can you send me the table's definition (ddl to recreate it) along with the indexes...

Ninja's_RGR'us (8/5/2011)

---

Hey Rhox I'd love to do a few tests with your particular case. Can you send me the table's definition (ddl to recreate it) along with the indexes...

GilaMonster (8/5/2011)

---

No. Don't switch to simple. It gives you...

Thanks for the support.

I will exlude this index (by using the @maxPageCount parameter) at this moment, so the other indexes can be maintenanced.

And for this big one, I will discuss...

crashdan (8/5/2011)

---

You are up against a wall on this. You will need more storage to accomplish the task. Which will require an outage to move the log to.

also: No downtime...

GilaMonster (8/5/2011)

---

Yes if could, in which case you need more disk space.

To rebuild an index in full recovery model you need as much log space as the total size of...