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

Thanks for the correction, Hugo. Moving too fast today.

Not sure why you would disable a clustered index then. Perhaps it was included to keep consistent syntax for all indexes? Seems...

It still isn't quite clear. The exact error and exact steps are needed, but you can debug this yourself as well.

run a trace on the 2000 server and watch what...

That makes more sense. I'm not familiar with terminal services licensing, but can you have 2 or 3 terminal servers under the same licensing? Is it by CAL or is...