+ Post New Thread
Results 1 to 15 of 15
MIS Systems Thread, SIMS Failing in Technical; Hi, Over the last three days, users have been unable to login to SIMS (reason 0 error message). To resolve ...
  1. #1

    Join Date
    Dec 2008
    Posts
    38
    Thank Post
    27
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS Failing

    Hi,

    Over the last three days, users have been unable to login to SIMS (reason 0 error message). To resolve this issue I have just been restarting the server. Today I have noticed that the SQL Server (SIMS 2010) service had stopped. After starting it up again, this then allowed users to login.

    This service seems to keep stopping everynight. Also, the C Drive is only 8GB and there is around 900mb of free space left. Is this normal?

    I have contacted Capita and their solution was to restart the service, but clearly the servuce will more than likely stop again tonight.

    Has anyone ever experienced this before?

  2. #2

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    12,441
    Thank Post
    1,682
    Thanked 2,041 Times in 1,485 Posts
    Blog Entries
    2
    Rep Power
    461
    We had this today, I was told to restart the service also, but it got stuck on "stopping service" (was like that for half hour) so in the end I restarted the server and all seems fine now.

  3. #3
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    963
    Thank Post
    550
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    Simple things first, do you run a backup overnight that stops the service to get at the LDF and MDF files?

  4. #4

    Join Date
    Dec 2008
    Posts
    38
    Thank Post
    27
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I've had to restart this service every morning for the last three days now. Bad time for it to be failing as well as everyone is doing reports.

  5. #5

    Join Date
    Dec 2008
    Posts
    38
    Thank Post
    27
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by TonyRidal View Post
    Simple things first, do you run a backup overnight that stops the service to get at the LDF and MDF files?
    NTBackup is run every night.

  6. #6

    Join Date
    Dec 2008
    Posts
    38
    Thank Post
    27
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Within the properties of the failing service, I have set the recovery option to 'Restart the server' if it fails.

  7. #7
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    982
    Thank Post
    38
    Thanked 179 Times in 144 Posts
    Rep Power
    97
    is Ntbackup scripted and if so what is the script. In the scheduled tasks is there an action to stop the srever

  8. #8
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    963
    Thank Post
    550
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    Question is, is the service crashing out or being stopped properly by something? Is it happening at the same time each day (see the system logs) ? if it's being stopped properly eg. by a "net stop", the restart option will have no effect.

    Pragmatically, you could just make a batch file containing
    Code:
     net start mssql$sims2008
    (replacing mssql$sims2008 with whatever your SQL instance is called if necessary) and make a scheduled task to make it run at 7.30 each morning

  9. Thanks to BatchFile from:

    finney_83 (24th June 2010)

  10. #9

    Join Date
    Dec 2008
    Posts
    38
    Thank Post
    27
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Mcshammer_dj View Post
    is Ntbackup scripted and if so what is the script. In the scheduled tasks is there an action to stop the srever
    It isn't me that usualy does the backups but after having a quick look, it is scheduled through BackupAssist. I am unsure of if this service is meant to stop or not during the backup process.

  11. #10
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    963
    Thank Post
    550
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    Quote Originally Posted by finney_83 View Post
    I am unsure of if this service is meant to stop or not during the backup process.
    I don't think you can copy the sims.ldf and sims.mdf if you don't? I've certainly always stopped the service first.

  12. Thanks to BatchFile from:

    finney_83 (24th June 2010)

  13. #11

    Join Date
    Dec 2008
    Posts
    38
    Thank Post
    27
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by TonyRidal View Post
    I don't think you can copy the sims.ldf and sims.mdf if you don't? I've certainly always stopped the service first.
    The service must be being stopped then when the backup is running, but once the backups have finished, it doesn't seem to be starting up again.

  14. #12
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    982
    Thank Post
    38
    Thanked 179 Times in 144 Posts
    Rep Power
    97
    why not use the dbattach with switches to backup the sims database?

    dbattach /backup /server=servernamehere\instancename /database=sims /user=????0 /password=??????? /auto

    This will create a backup in the backup folder os SQl

    If space is an isseu you can then use the tidybackup routine that Matt created and posted here on edugeeks a while ago

  15. Thanks to Mcshammer_dj from:

    finney_83 (24th June 2010)

  16. #13
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    963
    Thank Post
    550
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    Quote Originally Posted by finney_83 View Post
    The service must be being stopped then when the backup is running, but once the backups have finished, it doesn't seem to be starting up again.
    Then you would seem to need to either edit the backup procedure if you can (not familiar with backupassist I'm afraid), or create the batch file I mentioned up there /|\ and schedule it. If it's definately the backup that's stopping it and nothing more sinister, it's a safe permanent fix.

  17. Thanks to BatchFile from:

    finney_83 (24th June 2010)

  18. #14

    Join Date
    Dec 2008
    Posts
    38
    Thank Post
    27
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    After having another look at the backups, I think I know what is causing the problem. I will know for sure tomorrow what it is, and I will update this thread.

  19. #15

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,894
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    An 8GB C drive is very small, especially if your mdf and ldf are stored there, which is the default i think. Plus your docstorage would be there too, so you're looking at running out of space fast. Only 900MB free is pretty tight, and any process that needs to make a temporary file is going to clobber the machine. For example, making a backup of the database, and perhaps zipping it as some routines do will require making a temporary file the same size as the db! My daily SIMS backup is 3GB, until i zip it to 1GB, but if i don't have much spare room, it wont work. Doesn't stop the service, but it's not good for the system.

    Whatever the actual fault turns out to be, you need to take some drastic measures to make some room and expand the capacity somewhat.



SHARE:
+ Post New Thread

Similar Threads

  1. nslookup failing
    By sparkeh in forum Wireless Networks
    Replies: 2
    Last Post: 9th January 2009, 01:28 PM
  2. SIMs backup script after SQL 2005 migration failing...
    By mullet_man in forum MIS Systems
    Replies: 13
    Last Post: 23rd November 2007, 07:03 PM
  3. Failing Script.. sometimes.
    By jmair in forum Windows
    Replies: 8
    Last Post: 29th October 2007, 02:37 PM
  4. Sims failing to load
    By snakepottery in forum Windows
    Replies: 3
    Last Post: 9th January 2006, 12:27 AM

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
  •