Cool thanks for that 🙂

I managed to write a massive script that did everything

:whew:

Thanks again

@philcart Writing scripts would definitely be a good idea, if it becomes any more complex or any more issues come up I will probably go down that road.

Cool, thanks for the reply.

I have ended up just hardcoding the 'tempdb' for now. If a better way comes up I will update it but I see no real problem...

It means I freed up space and it works fine now.

I did go on a rather disjointed tangent to explain i noticed another issue but that is for another topic...

Cool, thanks you are absolutly right.

I don't want to back-up snapshot databases which means I will have to use T-SQL script instead of a database backup task in the maintenance...

Thanks Jack, that was it 🙂