+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 23
MIS Systems Thread, Ran out of space on the Sims drive, now it wont start! in Technical; Hi everyone I got a call this morning to say that Sims wasn't working. After trying it on my computer, ...
  1. #1

    Join Date
    Sep 2009
    Posts
    224
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    13

    Ran out of space on the Sims drive, now it wont start!

    Hi everyone

    I got a call this morning to say that Sims wasn't working. After trying it on my computer, this was true. I got the error saying "Reason 0".

    Anyway, after going onto the server, it seems that the Sims Drive was totally out of space (the partition is 85GB!) I've cleared off a few things and made 8GB of space...but the SQL Server Service Manager wont start.

    When i try and start the SQl server service manually (in the system tray), i first get an error saying "cannot find the specified path), then it says "An error 3 - (The System cannot find the specified.) occured while performing this service operation on the MSSQL Server Service"

    Any ideas?

    I arent great with Sims, and our LEA helpdesk guy (who normall responds really quickly), isn't responding to e mails yet.

    Thanks

    Aaron

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,785
    Thank Post
    715
    Thanked 1,440 Times in 1,193 Posts
    Rep Power
    359
    tried a reboot, you might need to do that to ensure it sees the space now...?

  3. #3

    Join Date
    Sep 2009
    Posts
    224
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    13
    Tried that, with no joy.

    I've just discovered something else too. i've checked the SQLAgent$Sims info...and the .exe file it needs to be able to start is missing...as is the full folder!!! No wonder it says it can't find the path!

    I dont think i even have a backup. This could be an issue.

    I'm wondering how this could have been deleted now.

  4. #4
    danrhodes's Avatar
    Join Date
    Sep 2008
    Location
    Wath Upon Dearne
    Posts
    1,513
    Thank Post
    157
    Thanked 181 Times in 150 Posts
    Rep Power
    68
    This is the fix for reason 0, not sure why your files arent there though?

    1 - Launch SQL Server Management Studio
    2 - Take a backup.
    3 - Paste the following into the query windows and then click execute

    use sims
    go
    exec sims.db_p_install
    exec sims.db_p_grant

    It does take a while, but will resolve the reason 0 error.

    D

  5. #5

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,232
    Thank Post
    894
    Thanked 1,780 Times in 1,534 Posts
    Blog Entries
    12
    Rep Power
    462
    Delete some of the backups it creates when doing an update. I think they are in the setups directory.

  6. #6
    danrhodes's Avatar
    Join Date
    Sep 2008
    Location
    Wath Upon Dearne
    Posts
    1,513
    Thank Post
    157
    Thanked 181 Times in 150 Posts
    Rep Power
    68
    Backups if you do them through Sims.net are stored in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup as default.

    If you use the Management Studio you will have specified a default location.

    But more to the point why do you not have a backup, as you mentioned in your post??

  7. #7

    Join Date
    Sep 2009
    Posts
    224
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    13
    I feel like an idiot.

    After getting a call from our LEA Helpdesk, it seems that this service Iím on about shouldn't even be started anyway....because this is the "old version" of Sims.

    Anyway, to cut a long story short...it all works now. had I tried Sims after the first re-boot of the server...Iíd have known this...but, because I was basing my opinion on weather the system was working or not on this system tray icon on the server (which of course stayed red after the re-boot)...I didnít.

    I feel like an idiot lol

    Thanks the replies to this thread anyway...Iíll keep the thread alive in case anyone in future has this same issue.

    Thanks again

    Aaron

  8. #8

    Join Date
    Sep 2009
    Posts
    224
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    13
    Quote Originally Posted by FN-GM View Post
    Delete some of the backups it creates when doing an update. I think they are in the setups directory.
    Just done this...and now i have 22GB of space

  9. #9

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,232
    Thank Post
    894
    Thanked 1,780 Times in 1,534 Posts
    Blog Entries
    12
    Rep Power
    462
    Quote Originally Posted by aaronjwilkinson View Post
    Just done this...and now i have 22GB of space
    They are all zipped up. I get shut from time to time. I think this are there for when you run solus.

  10. #10
    danrhodes's Avatar
    Join Date
    Sep 2008
    Location
    Wath Upon Dearne
    Posts
    1,513
    Thank Post
    157
    Thanked 181 Times in 150 Posts
    Rep Power
    68
    Good as long as its sorted now :-)

  11. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Quote Originally Posted by FN-GM View Post
    They are all zipped up. I get shut from time to time. I think this are there for when you run solus.
    They don't get zipped any more. SOLUS will do a backup before each upgrade. Also people can do it via SysMan, or FMS (if you use it). Generally the timetabler does a backup before transferring it across. Have a look at tidybackup, set it as a scheduled task, it'll delete the old backups and can compressed the uncompressed backups (big disc space savings).

  12. #12

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 770 Times in 598 Posts
    Rep Power
    183
    Quote Originally Posted by danrhodes View Post
    Good as long as its sorted now :-)
    I bet you're taking a backup now too

  13. #13

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,232
    Thank Post
    894
    Thanked 1,780 Times in 1,534 Posts
    Blog Entries
    12
    Rep Power
    462
    Quote Originally Posted by matt40k View Post
    They don't get zipped any more. SOLUS will do a backup before each upgrade. Also people can do it via SysMan, or FMS (if you use it). Generally the timetabler does a backup before transferring it across. Have a look at tidybackup, set it as a scheduled task, it'll delete the old backups and can compressed the uncompressed backups (big disc space savings).
    whats tidybackup? Is it something Captia provide? where do i find it please?

    Thanks

  14. #14
    danrhodes's Avatar
    Join Date
    Sep 2008
    Location
    Wath Upon Dearne
    Posts
    1,513
    Thank Post
    157
    Thanked 181 Times in 150 Posts
    Rep Power
    68
    I take a backup every night using Backup exec to NAS in a different building.

  15. #15

    Join Date
    Sep 2009
    Posts
    224
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    13
    Quote Originally Posted by danrhodes View Post
    I take a backup every night using Backup exec to NAS in a different building.
    May i ask exactly what you backup in relation to Sims?

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Itunes wont see cd's in disc drive
    By lafleur1977 in forum Hardware
    Replies: 0
    Last Post: 29th May 2009, 11:44 PM
  2. SpaceGuard - Service Wont Start Please Help
    By EduTech in forum General Chat
    Replies: 2
    Last Post: 22nd October 2008, 04:29 PM
  3. sims not enough space on drive
    By markcuk in forum MIS Systems
    Replies: 2
    Last Post: 10th June 2007, 05:15 PM
  4. Out of drive space on domain?
    By Samson in forum Windows
    Replies: 7
    Last Post: 5th June 2007, 10:14 PM
  5. Replies: 14
    Last Post: 15th June 2006, 09:11 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
  •