A file closes unexpectedly on the server.
Operating system version
Windows XP Professional 2002 Service Pack 3. Windows Server 2003 R2
Description of the issue
From time to time one of the databases on the server suddenly closes. There are 7 other files which never do this.
Does anyone have any suggestions as to what might cause it. Can there be too much stored data, can there be too many scripts, can there be too many fields?
Steps to reproduce the problem
I do not know what causes it to happen. Yesterday morning everything was working fine, then suddenly one of the files closed. It happens infrequently, so I do not have any clue as to what might cause it. It is a problem because there are many clients using the database and they are prevented from using it until I go in and fix it.
Exact text of any error message(s) that appear
I do not get an error message. The file is not available to open.
I do not know if it is relevant, but I am not able correct the problem using the Admin Server Console. I can log into it OK, but when I click on databases to work in it I get the error message 'Admin Server Connection Error: An unknown error has occured.'