button_ripple Posted May 1, 2009 Posted May 1, 2009 (edited) Yesterday we lost the power to our server room, since then our SIMS/FMS server will not allow anyone to use either program. The original problem was: Whenever anyone tried to log into FMS the software would allow them to type their username and password but when they clicked on OK the FMS screen would jump up and then disappear again. We logged a support call with Capita and they remoted in and did a few things, but didn't fix the problem. Now no database on the server (we have SIMS, 5 FMS's and Vericool) can be opened, it just always gets flagged as suspect. Anyone got any ideas?? All the databases except FMS were working before capita remoted in! Would the easiest thing be to restore the databases to the nearest working backup (wednesday)? EDIT: Just found out that the only databases being flagged as suspect are SIMS, Vericool and our FMS Infant database Edited May 1, 2009 by button_ripple
rh91uk Posted May 1, 2009 Posted May 1, 2009 If your using SQL Server 2005 .... CodeProject: How to Restore SQL Server 2005 Suspect Database. Free source code and programming help I had this problem with my personal sql server DB's ... this fixed it .. hopefully it does for you too! R 1
Steve_T Posted May 1, 2009 Posted May 1, 2009 Its not in single user mode is it? http://img383.imageshack.us/img383/1050/multiuser.png 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now