i use sql server 2000 as a backend for my hospital database. i have two databases. one databse is hanging up every 48 hours or sometimes every 24 hours. i have to restart the MSSQLSERVER servive everytime it will be ok again it reoccurs .no errors are reported in event viewer.users are able to connect to database but they cannot save anything into the database.
other database in the same server is working fine.
is there any issue with the logs.