+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, No access to any database on SQL server in Technical; Yesterday we lost the power to our server room, since then our SIMS/FMS server will not allow anyone to use ...
  1. #1
    button_ripple's Avatar
    Join Date
    Dec 2007
    Location
    Luton
    Posts
    346
    Thank Post
    93
    Thanked 20 Times in 18 Posts
    Rep Power
    18

    No access to any database on SQL server

    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
    Last edited by button_ripple; 1st May 2009 at 09:21 AM.

  2. #2
    rh91uk's Avatar
    Join Date
    Sep 2008
    Location
    UK
    Posts
    877
    Thank Post
    137
    Thanked 132 Times in 114 Posts
    Rep Power
    36
    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

  3. Thanks to rh91uk from:

    button_ripple (1st May 2009)

  4. #3

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    13
    Its not in single user mode is it?
    http://img383.imageshack.us/img383/1050/multiuser.png

  5. Thanks to Steve_T from:

    button_ripple (1st May 2009)



SHARE:
+ Post New Thread

Similar Threads

  1. vmware SQL database
    By badders in forum Thin Client and Virtual Machines
    Replies: 5
    Last Post: 29th September 2010, 03:26 PM
  2. Restoring a SQL 2000 Database
    By Neville in forum Windows
    Replies: 0
    Last Post: 12th March 2009, 10:09 AM
  3. moving form access to sql server
    By RabbieBurns in forum Office Software
    Replies: 3
    Last Post: 27th August 2008, 04:20 PM
  4. SQL Database Migration-HELP!!
    By Mr_M_Cox in forum MIS Systems
    Replies: 3
    Last Post: 16th August 2007, 04:24 PM
  5. Backing up SQL database ?
    By Kyle in forum Windows
    Replies: 4
    Last Post: 8th June 2006, 10:36 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •