Not a bad suggestion. I have considired this, but not done it.

I dont know whether the last six months worth of data is any smaller in comparison to previous.

My original problem was a lack of disk space which caused performance issues. Therefore deleting and shrinking helped to free up some space and allowed the database to respond.

I could potentially now move the last 6 months to a new file, but once this is done, I assume I will still need to get the data older than 6 months deleted.

Am I wrong to think that I will therefore be adding another step into my process but still end up with the same result at the end of the process?

Regards

T