Take the 2-minute tour ×  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.
share|improve this question What version of SQL Server? – 
RBarryYoung Apr 24 '13 at 18:41 sql server 2008 –  Phillip Apr
24 '13 at 18:53 add comment  migrated from stackoverflow.com Apr
24 '13 at 19:34  This question came from our site for
professional and enthusiast programmers.  3 Answers  up vote 6
down vote accepted  Is your database set to auto-close? If auto-
close is on your database shuts itself down and the update
statement would then cause the database to come back online,
kick off automatic system checks, and could raise this error if
the update statement comes in at the same time.  What other SQL
Server error messages are coming in at or around the same time
as the 9001 error?  What Wind