Just to double check...in your production database after it gets restored, did you manually check to see if it's still set to Simple?

Can you try running dbcc sqlperf(logspace) and see...

SeanLange (10/22/2010)

---

o rly? I didn't know that. I thought it would...

SeanLange (10/22/2010)

---

First thought is to ask if you really need this field as ntext. Can you use nvarchar instead. It is pretty big at 4,000 characters. If you specify it...

It is logged, but is nowhere near the amount of logging that say a reindex does (even with fullscan).

Was this a failed install, or an install/uninstall? Did the SQL Uninstaller remove the group, or did you do it manually, and was this before or after you ran the...

If I'm restoring a database for the first time, or one that I don't do regularly enough to already have a script for, I will always go through the GUI,...

If you can access the database while it's growing, you can check the sys.databases table and look at the log_reuse_wait_desc column to see why log space can't be reused (and...

Typically it's because of a clustered index and having to reorder pages when you insert new non-sequential data.

If there are no indexes at all (table is a heap), then possibly...

You can't put tasks into the parent maintenance plan..everything gets put into a subplan, and then that's what you can schedule (and rename from subplan1). Even if you only have...

I thought it used the windows regional settings for that?

Or maybe that was just excel..

MostInterestingMan (10/12/2010)

---

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...

Doing a transaction log backup does not release space back to the OS. The file stays allocated at that size (for good reason).

If you run DBCC SQLPERF(logspace), it should show...

Agreed - check your MAXDOP.

If all cores are pegged, then maxdop is set to 0 (or as many cores as you have)..this will either speed up the query, or lock...

In the step of the job on the Advanced tab, specify an output file (.txt). It will log all errors to that.

You should also see more detail in the step...

drew.allen (10/12/2010)

---

Derrick Smith (10/12/2010)

---

This part is the issue:

AND (NOT email IN (SELECT email FROM failures))

AND (NOT email IN (SELECT email FROM removes))

AND (NOT email IN (SELECT email FROM contacts));

I'd be...