Are you running a multicore processor machine? If so the article below should solve your problem:

http://support.microsoft.com/kb/954835

GSquared (11/19/2010)

---

You're trying to get SSIS to output an Excel file, right?

Just about any documentation on SSIS will tell you how to do this. Just Bing/Google/whatever "ssis export excel"...

Can you reference an SSIS article that outlines how to accomplish this?

Thanks for all of your inputs...

RESTORE DATABASE mydatabase

FROM DISK = @Backup

WITH REPLACE, RECOVERY

fixed the issue. Again thanks.

The wait_type is NULL.

At this point is it okay to just drop it and attempt to re-restore using...

Sorry Gail, I edited the syntax.

GilaMonster (11/11/2010)

---

That's recovering, not restoring.

The DB will go into...

GilaMonster (11/11/2010)

---

Was this DB restored from...

Yes.

GilaMonster (10/12/2010)

---

Good idea, if you want to absolutely cripple database performance, fragment your indexes to hell...

GilaMonster (10/12/2010)

---

MostInterestingMan (10/12/2010)

---

Gail, something interesting happened when I backed up the 7gb log file. Note that the DB with the 7gb log file is now in FULL recovery. The file...

GilaMonster (10/7/2010)

---

MostInterestingMan (10/7/2010)

---

For the DB with 7GB log I am not doing any log backup until I investigation why the log grew to 7GB in the first place. I have...

GilaMonster (10/8/2010)

---

Way, way, way too small to worry about.

Under 24 pages, an index rebuild will likely do nothing at all. It's generally considered that 1000 pages should be about the...

MostInterestingMan (10/8/2010)

---

GilaMonster (10/8/2010)

---

How big is the index? How many pages.

Update stats has nothing to do with index fragmentation, so running a stats update won't do a thing to the index...

GilaMonster (10/8/2010)

---

How big is the index? How many pages.

Update stats has nothing to do with index fragmentation, so running a stats update won't do a thing to the index fragmentation...