patwarimk (2/22/2010)

---

Hello, This is Praveen, Iam a tester and please can you give me some information while migrating Database from SQL Server 2000 to SQL Server 2008 what we need...

Thank you for this. I'm definitely voting on the connect item and will take a look at all suggestions as I really don't want to create a Gantt Chart Manually.

I did read the whole comment. It's just that the first paragraph of any email or post sets the tone for the rest of it. Which means your final comment...

Tom,

I understand...

I'm sure there are a lot of differences between your servers and mine, but this fix was a permanant fix for us. I've had it in affect for almost 2...

Precaution and dropping / recreating your maintenance plan are your only two solutions for now.

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.