Gail,

I'll check them out, but they appear to be down now. Or down from the Denver area.

The only hesitation I have with changing color or marking something as an answer...

Leslie,

The History Cleanup task should get those .txt files. The Maintenance cleanup task only works with backups. I prefer doing things like Mike is with a script since it gives...

Fingers crossed. Good luck! Make notes, let us know how it goes. It will be good blog fodder 😉

Just saw this and thanks for the nice comment!

We've done some before, seems like it's hard to just get the answer in a question. 100% of people might use 2005, but only in some instances. If you think...

And I'm beginning to think this thread will never end.

We are working on some JS and server side formatting for both SQL and XML code to make it work better.

A lot of what Gus has listed are reasons I'm concerned about this.

I think things work well as is. Relatively few people would likely use any "improvements"

glad I could help. I need to get a better article written on this as I know it's an annoying thing to figure out.

DTS has a runtime. It should work and there's still a compatibility mode. If it works on 2005, should still work on 2008.

As far as rewriting DTS packages. If you...

Thanks for the update and solution. That shouldn't happen often, but it's good to consider removing and recreating the job.

No, shrink should be rarely run. Only when something happens you didn't expect.

select * from sys.database_files

in master should help.

You can go to sysinternals as well and get the filetracker and see if the file is being held open by the SQL process.

I'm not sure you get a lot from 2 partitions. I suppose one could become corrupt and not the other, which would be nice to have data on one, logs/backups...

does is change on stop/restart of SQL?

strange, I'd be concerned that you are using the wrong files. Have you tried to rename a file? See if SQL is using it?