+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, FMS Famous Purple Hand! in Technical; Hello all, long time reader, first time poster, and all that... We've got the usual SIMS/SQL setup here, but recently ...
  1. #1

    Join Date
    Jul 2005
    Location
    Leicestershire
    Posts
    50
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    FMS Famous Purple Hand!

    Hello all,

    long time reader, first time poster, and all that...

    We've got the usual SIMS/SQL setup here, but recently have been having problems with FMS... at the worst time of year for FMS problems of course!

    The problem is quite simple. The 'SQL Anywhere - SIMS_SQL_DB_SERVER' Service is stopped when we get in, in the morning. From the looks of it, it failed to be restarted by the backup program when the backup finished.

    If you try and restart the service, either through the GUI, or through the services console, you get a number of errors in the event log -

    1. An engine with that name has already started
    2. Service not able to access Desktop
    3. Could not start server

    On friday we simply restarted the server, which fixed thr problem.. but obviously this can't be the best solution.

    This morning we noticed that a service called 'network DDE' was stopped (for some reason), and restarting this service allowed us to restart the SQL Server service.

    Any ideas? Anyone seen this before?

    Regards

    Adam Short
    Assistant Network Manager
    John Cleveland College
    Leicestershire

  2. #2

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,915
    Thank Post
    708
    Thanked 549 Times in 364 Posts
    Blog Entries
    3
    Rep Power
    204

    Re: FMS Famous Purple Hand!

    <waves at adam from across the other side of the county>

    Hi Adam stupid question how is backup script stopping the sql services etc and in what order..

    cheers

    Russ

  3. #3
    StewartKnight's Avatar
    Join Date
    Jun 2005
    Posts
    1,587
    Thank Post
    2
    Thanked 27 Times in 21 Posts
    Rep Power
    30

    Re: FMS Famous Purple Hand!

    Have you considered you might have a virus. I know there are some that close down the SQL server

  4. #4

    Join Date
    Jul 2005
    Location
    Leicestershire
    Posts
    50
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: FMS Famous Purple Hand!

    Haven't considered a virus, but will double double check the antivirus to make sure it's clean...

    Here is the order of service stop/starts in the script:

    start /wait net stop "Removable Storage"
    start /wait net start "Removable Storage"
    start /wait net stop "SQL Anywhere - SIMS_SQL_DB_Server"
    start /wait net start "SQL Anywhere - SIMS_SQL_DB_Server"

    any use?

    Adam

  5. #5

    SpuffMonkey's Avatar
    Join Date
    Jul 2005
    Posts
    2,224
    Thank Post
    54
    Thanked 276 Times in 184 Posts
    Rep Power
    133

    Re: FMS Famous Purple Hand!

    We get the purple hand from time to time as well. Sometimes I find that rights to temporary files on the local machine have gone awry (PDOUSER or sometihing and the SIMS folders - not at work now). Other times I've no idea - but then it starts working again - if you find a "proper" fix - I'd love to know.

  6. #6
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,958
    Thank Post
    248
    Thanked 49 Times in 45 Posts
    Blog Entries
    2
    Rep Power
    46

    Re: FMS Famous Purple Hand!

    Had exact same problem Adam but can't remember fix right now. Sure we fixed it by re-jigging the backup routine tho'. Do you have centralised sims support there?
    if you stll have the problem when i check back i'll look it up.

  7. #7

    Join Date
    Jul 2005
    Location
    Leicestershire
    Posts
    50
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: FMS Famous Purple Hand!

    we do have SIMS support with our LEA, or LA, or whatever they are now...

    The only problem with that is, they recently lost their most experienced techy... he now sit's in the same office as me, he moved here to be the network manager, and he doesn't know how to fix it either...

    Any re-jigging advice would be grately apprieciated.

    Cheers

  8. #8
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41

    Re: FMS Famous Purple Hand!

    Just a thouht but is he sql any service being started during backup?

  9. #9

    Join Date
    Aug 2005
    Location
    Birmingham, UK
    Posts
    490
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: FMS Famous Purple Hand!

    Why do you have to stop the sql service anyway out of sheer curiosity

  10. #10
    Guest

    Re: FMS Famous Purple Hand!

    Quote Originally Posted by apeo
    Just a thouht but is he sql any service being started during backup?
    Good point, could be that the backup is taking longer than the gap between the service stoping and restarting.

  11. #11
    Guest

    Re: FMS Famous Purple Hand!

    Sorry, bit of an error in my first post I've realised...

    The script that runs before the backup re-starts the sql anywhere service, so as to release the db file (incase some users crashed out at the end of the day), hence the stop/start lines in the script... the stop/start for the backup service refreshes the backup servic so that it recognises there's a new tape in the media library.

    Does that help?

    cheers

  12. #12

    Join Date
    Jul 2005
    Location
    Leicestershire
    Posts
    50
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: FMS Famous Purple Hand!

    Silly me... forgetting to log in! /\

  13. #13
    ChrisC's Avatar
    Join Date
    Mar 2006
    Location
    Dorset
    Posts
    767
    Thank Post
    2
    Thanked 1 Time in 1 Post
    Rep Power
    18

    Re: FMS Famous Purple Hand!

    Ok, possibly I'm missing the point, but can't you stop the sql service, run the backup, then restart the sql service?

SHARE:
+ Post New Thread

Similar Threads

  1. We are famous.
    By russdev in forum General Chat
    Replies: 47
    Last Post: 22nd October 2007, 09:22 PM
  2. Second hand Mac Wanted
    By FN-GM in forum Mac
    Replies: 5
    Last Post: 7th September 2007, 12:10 PM
  3. Buying Second-hand kit
    By SimpleSi in forum Hardware
    Replies: 13
    Last Post: 18th June 2007, 11:07 AM
  4. Printers- Second Hand
    By ticker in forum Hardware
    Replies: 9
    Last Post: 3rd May 2006, 04:04 PM
  5. Hand in work securely
    By ken_kaniff in forum How do you do....it?
    Replies: 3
    Last Post: 5th January 2006, 12:24 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
  •