Unless it's included in SP2 or the SP1 Hot Fix, no. We don't have it applied to our clustered servers.

Of course, the initial solution I posted worked for us, so...

mirde (1/15/2010)

---

... basicly what I tried is "backing" it up and then I created a new DB and tried restoring to it. this did not work well, the error message...

Caveat - I am using Litespeed for my backup maint. plans.

However, I have had the same issue. If I delete a database *before* altering the plan, the plan no longer...

Now, see, I've never heard of xp_DirTree before now. And for a moment, I actually considered changing the code I had to use it.

And then you spoiled it with...

Ah, but your response gives me a lot more information than I had before. Now I know what to look for and how to reconsider the partitioning idea.

Thank you.

And the user db is on the same drive or a different drive? How much space does it have available to it and is its Autogrowth set to Unlimited?

Run the...

You said tempDB only...

The "single drive" is actually a SAN. It's either Raid 5 or Raid 1 + 0, but I'm betting on Raid 5.

The plan is to keep everything in the...

Just remember that xp_cmdshell is off by default and you'll have to turn it on before you can use it in this manner.

OLTP database. The partition would be storing historical records, but apparently the end users like to do a lot of "inception to current" summary reports. (I just found out about...

Sorry, forgot to...

1053MB is NOT MUCH when it comes to TempDB.

Understand that just because it's showing free right now, does not mean there's enough space to do what your transaction is attempting...

SWITCH? Is this something available in SQL 2005?

I don't see it in BOL.

The only tools I'm aware of compare Folders to Folders and Databases to Databases, not Databases to Folders.

The best thing you can do is set up dual monitors on your...

Have you checked the actual hard drive space? Locate not only your user db files, but the tempDB files. If tempDB is full, it can also cause this error.

AFA the...