+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Installing a new sims server in Technical; Having installed sims several times I wasn't particularly daunted by this. However as usual something awkward had to happen. I ...
  1. #1
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,202
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    29

    Installing a new sims server

    Having installed sims several times I wasn't particularly daunted by this. However as usual something awkward had to happen. I installed the sims system and it updated everything (2hours) then I was able to log in! I then logged out stopped the MSSQL service so that I could copy the database files from the old server over but when I did I couldn't restart the service it just tried then stopped again, has anyone had this problem before?


    Wes

  2. #2
    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: Installing a new sims server

    From what i've been told, if you want to restore the database back you need to use dbattach to attach and detach the data. Dont think its a simple case of copy over sims database. So your sql service wont start at all?

  3. #3
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,036
    Thank Post
    68
    Thanked 74 Times in 58 Posts
    Rep Power
    34

    Re: Installing a new sims server

    Yep, use DBAttach. It's the only way to do it sucessfully.

    You may already know this but:

    Don't forget to also transfer the Docstore folder and if you've changed your server name you must change the name of the subfolder that has the old server name eg docstore\newservername\sims\sims\sims. Make sure it's done at the same time as the database transfer or you may not have a matched set.

    Also if you use NovaT\Cover etc make sure you transfer all those files as well. I forget to do this when I transfered to a new server and it was a few days out on the data.

    Also FMS if you use it will need to be setup again on the new server with all the databases in the right place.

    After transfereing the database try to run a report. If it fails with an error about the file not existing in the Document Server it's because SIMS does not know where the Docstore folder actually is despite the socument server giving no errors.

    There's a command to use in order to set the path again. I'll dig it up if you want.

    Good luck

    HBJB stops teaching Granny to suck eggs.

  4. #4
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,036
    Thank Post
    68
    Thanked 74 Times in 58 Posts
    Rep Power
    34

    Re: Installing a new sims server

    Forgot to mention that I took the opertunity to install MSSQL to another directory rather than the default C:\Program Files\MSSQL Server folder when I moved to a new server. This enabled me to store the SIMs backups in a sensible place and not on the system disk.

    Is sims the only instance running on this server or is there another programme using it as well?

    HBJB

  5. #5
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,202
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    29

    Re: Installing a new sims server

    Yep DBAttach worked perfectly! Now I just need to get FMS installed right



    Wes

SHARE:
+ Post New Thread

Similar Threads

  1. Problems installing SQL 2005 for SIMS
    By timbo343 in forum Windows
    Replies: 6
    Last Post: 7th November 2007, 10:27 AM
  2. Installing a SIMS server
    By nicholab in forum MIS Systems
    Replies: 6
    Last Post: 21st August 2007, 11:58 PM
  3. Installing a new SIMS server ... in exam season !!
    By bobwright in forum MIS Systems
    Replies: 8
    Last Post: 21st June 2007, 08:49 AM
  4. Installing SIMS/NOVA T on a laptop
    By randle in forum MIS Systems
    Replies: 4
    Last Post: 16th March 2007, 05:22 PM
  5. Replies: 18
    Last Post: 8th July 2006, 12:13 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
  •