There are a lot of people following this thread... hopefully they'll have other ideas. Mine...

DECLARE @Table_Name VARCHAR(128)

DECLARE @sql0 VARCHAR(1000)

SET @Table_Name = 'MyTable'

SET @sql0 = 'sp_rename '''+ @Table_Name + '.Active'', ''IsActive'', ''COLUMN'''

PRINT @sql0

--sp_rename 'MyTable.Active', 'IsActive', 'COLUMN'

SC48035 (5/31/2011)

---

Hello All: Please avoid trivial arguments on this forum and kindly take a look at the attached execution plans and DDL scripts. I would like to accept the fact...

I've found a few links on google about this error... at least you have other options if it occurs again.

NOt 100% sure about this but if the db wasn't cleanly shutdown or if there was a very long running transaction is has to be rolled forward / back before...

What did you find in the windows and sql logs?

1 - See if you can ping the remote server >> fix all switches routers and ports

2 - See what connection types are allowed (can try ip over server name...

SKYBVI (5/31/2011)

---

@ all

thanks guyz,

I again tried restoring thru query...

and this time it got restored...it took 7 hrs to retore 300gb db...

its too much time i guess....but then all's...

I'd still try the update stats trick first. Fragmentation might slow the query down but I've never read that it changes the execution plan... maybe Gail has more info...

RTaylor2208 (5/31/2011)

---

This particular index is excluded from index maintenance due to the transaction log growth during the process.

The tables involved are huge just over 2 TB between them....

Does it have a magic exec...

RTaylor2208 (5/31/2011)

---

Company policy deems this as maintenance that has to be performed during a maintenance window.

However it looks like is definetly a fragmentation issue as now that I have re-ran...

Peeking my interest... why could you need maintenant window to update the stats?

Update the stats after 90 minutes during the day.

http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/

Let me...