That sound like shear heaven...

He Grant, your script didn't work for me, not quite sure why. But you did set me on the right path and with some Googling I got there. This one...

If I were in your position I would run the trace as you have it now. Then load the data into a table and use sql-queries to delete all the...

I've also experienced the problem. Not with a failover, but on a system where the time was changed.

In my experience there are only two solutions:

- stop and start the SQL...

I'm assuming you mean transaction logs.

You can het rid off transaction logs by using dbcc shrink to shrink it down to zero, then using the dbcc shrink emptyfile option. Then...

Hello Guus,

Did changing that setting ever resolve the problem?

I did not shrink without starting. I started in single user mode (starting with a small tempdb, something I did not know before hand) and then shrunk a database.

Many, many, many thanks for all the replies. Starting up in single user mode turned out to be our way in. I shrinked one of the largest databases and could...

All thanks for the advice.

Noeld, I realise the SSIS packages use xp_delete_file, but our old SSIS Maintenance Plans didn't clean up old text files either. We are at SP2, but...

I didn't know about xp_delete_file. It might be a solution for us, but I see it doesn't work for txt files (not surprising, as cleaning up txt files in SSIS...

I was mistaken earlier when I claimed I stopped and started a Service to get the jobs to appear. What I in fact did was open the Maintenance Plans and...

I was able to get the jobs to appear by stopping and starting one of the services. Can't remember which one right now and can't check it as I'm at...

I've been able to get there (on MS SQL Server 2005), with thanks to directions at http://sqlserver-qa.net/blogs/tools/archive/2007/09/09/value-of-9-6-2007-12-00-00-am-is-not-valid-for-value-value-should-be-between-mindate-and-maxdate.aspx about how to open, save and modify existing Maintenance Plans.

It's not...

Hello Anthony,

Thanks for the info, but how do I open an existing Maintenance Plan in the Business Intelligence Development Studio? From what I see I can't log into the MS...

Hi Steve, I've tried this in both SQL Profiler 2000 and 2005. Both show the same behaviour.

Mani, I know that's one way to work it. However, judging by the amount...