We recently moved to a SQL Server that's on a VPS and every now and then we get a 9001 error when trying to do an update.
Rebooting the server fixes the problem.
I changed the maximum server memory (in MB) to 2000 because it's a 4GB VPS.
But I just don't know what's causing the error.