I am facing a below problem with SQL server
which had database of size 4GB with one
database file and one log file on same drive.
when 2 or more users query the database
it goes into the recovery mode.

(2 GB of free space are avaiablee on same drive.)
Please suggest me a solution to solve it.

Regards
Milind Baviskar

milind.baviskar@inteliment.com
milind_baviskar@yahoo.com

Any particular reason why you are asking this question on the message board dedicated to support of 24x7 Scheduler, 24x7 Automation Suite and other "24x7" products? Is the problem related to usage of these products?

: I am facing a below problem with SQL server
: which had database of size 4GB with one
: database file and one log file on same drive.
: when 2 or more users query the database
: it goes into the recovery mode.

: (2 GB of free space are avaiablee on same drive.)
: Please suggest me a solution to solve it.

: Regards
: Milind Baviskar

: milind.baviskar@inteliment.com
: milind_baviskar@yahoo.com

Dear Milind,
The reason for this problem may be that the MSSQL is not
able to fetch some of the components/files form installation
folder of MSSQLserver installed in your mahcine.
possible Solution:
Take a backup of you database,re-install MSSQL with SP4(latest). >.