:), You are welcome.

One more note: Saw "Now You See It" this weekend, and it was fantastic. I bet lots of you woul dlove the twists and turns.

We blame it on youth and immaturity, but that's a lot of it. There are driving reasons for this, and I agree with you they don't make sense, but I'm...

you say mirroring was turned off or disabled, but that doesn't mean it was done correctly. If it's not removed from the source, and you don't have a destination, the...

No, do not play with tempdb for encryption. This happens automatically when you enable TDE in another database. This is a special, system database. The way you work with user...

First, do this for one server. Make a job that runs xp_fixeddrives and inserts the results (and the date) into a table on the instance. Write a cleanup task/job that...

+1 to what Sean said.

Don't use them, and don't depend on them.

and "it" was?

(someone else might search this post. Be nice to provide the solution).

It looks like the cleanup task failed, not the backup. Did you check the backup file?

As mentioned above, you should have a detailed log for the package. Don't use the...

This week is the first SQL in the City of 2013. Anyone coming?

Gary Varga (6/17/2013)

---

For too long we have rolled out the young/immature industry arguments. We must stop because quite simply: we know better.

A lot of these industries which have compliance, regulatory...

How big are your log backups? Check the size for each hour. If they are small, then you have something preventing the truncation of the log, like replication or mirroring...

At this point I wouldn't drop the master key. That won't help with your encryption status.

If you cannot drop this (encrypted state = 2) database, or do not have an...

Lynn Pettis (6/14/2013)

---

***************************************************

I am officially going to Afghanistan!

I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well there with me leaving there...

It should complete by itself. Has the progress changed at all?

If not, then I think you are in trouble. I'd backup the database, or copy out all data/schema and my...