+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 29 of 29
MIS Systems Thread, SIMS SQL 2008 migration utility in Technical; Originally Posted by support-it Any info could help. Done the SQL migration onto a new machine and all is working ...
  1. #16

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,051
    Thank Post
    275
    Thanked 722 Times in 550 Posts
    Rep Power
    326
    Quote Originally Posted by support-it View Post
    Any info could help.

    Done the SQL migration onto a new machine and all is working ok apart fron the document server. I have remapped and setup in sims. When I import reports they import into sims\documents and not Docstorage on the root of the drive as I have set it up. The result of this is that no reports will now run.
    Have you gone into SIMS, Tools, Setups, Document Management Server and set it to the new server?

  2. #17

    Join Date
    Apr 2009
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi.

    Yes, setup the document management server in sims. tested ok. Checked the config file in C:\Program Files\SIMS\SIMS .net Document Server

    and this shows it pointing to c:\docstorage.

    If i move the files from the sims directory to the docstorage directory, when I then try to run a file it says it does not exist.

  3. #18
    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
    In the docstorage directory is there another directory with the same name as the server?


    Wes

  4. #19

    Join Date
    Apr 2009
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    No there is no folder structure under docstorage. Normally this gets created when reports are imported.

  5. #20
    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
    Or you could just create the folder structure mentioned above and then move or copy the folders under the old doc storage area named 00,01,02 I think to this?


    Wes

  6. #21

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    i use the dmconfig.exe held in C:\Program Files\SIMS\SIMS .net Document Server :

    Code:
    dmconfig /D:C:\DOCSTORAGE
    because it's always a bit odd doing it from within SIMS.
    Plus, whenever i move server, rename server (all virtual of course) the Docstorage seems to go back to a weird default of C:\SIMS !
    Last edited by vikpaw; 12th December 2009 at 06:23 AM. Reason: typo

  7. #22

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,662
    Thank Post
    320
    Thanked 311 Times in 253 Posts
    Blog Entries
    8
    Rep Power
    122
    It's not something within the SIMS.ini that is causing that Vik?

  8. #23

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Quote Originally Posted by GREED View Post
    It's not something within the SIMS.ini that is causing that Vik?
    Not that i can see. sims.ini references a log file in local settings\temp which has that location in it, but i figure that file is created after the event rather than controlling it.

    no matter, i know the issue and that i have to change it every time.

  9. #24
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,456
    Thank Post
    279
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    This all looks fairly straightforward - is it truly that simple or is there a (higher than normal) chance of things going hideously wrong?

  10. #25

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    Stupid thing doesn't set the correct sql 2008 backup path correct, you have to select it (middle option), then custom path (bottom option) and add "\backup"

    Failing that you have to use the setsimsbackuppath to change it. Otherwise you end up with backup files in:

    \mssql\

    rather then

    \mssql\backup\


    Still minor issue, never heard of any truely bad thing happening.

  11. #26

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    The people who write those documents manage 30gb databases for a living. We support a 2gb database, but it's not our only job. Splitting the mdf and ldf up may indeed increase performance, but the support aspect it drastically increased. So much so it's cheaper, easier to just get faster hard drives.

  12. Thanks to matt40k from:

    Oops_my_bad (15th February 2010)

  13. #27
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,530
    Thank Post
    815
    Thanked 380 Times in 317 Posts
    Blog Entries
    12
    Rep Power
    80
    Yeh one single point of failure can also be a good thing 2 drives = twice as likely for one of them to fail.

    Anyway with the advent of SSD drives I have not had a drive fail in a long time.

  14. #28

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,855
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    181
    Quote Originally Posted by ittech View Post
    2 drives = twice as likely for one of them to fail.
    How exactly do you come up with that one?

  15. #29

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    Well if the data is split between two "drives"*...

    * single hard drive \ raid array \ crystals (as seen on stargate TM)

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [SIMS] SIMS Tidy Backups - SQL 2008 - Autumn release
    By matt40k in forum MIS Systems
    Replies: 49
    Last Post: 11th February 2011, 01:12 PM
  2. Migrate SIMS database to SQL 2008
    By speckytecky in forum MIS Systems
    Replies: 8
    Last Post: 10th October 2009, 09:43 AM
  3. SIMS SQL 2008 migration
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 8th August 2009, 12:08 AM
  4. Ease of SIMS migration to SQL 2005
    By Ric_ in forum MIS Systems
    Replies: 12
    Last Post: 29th February 2008, 02:06 PM
  5. SIMs backup script after SQL 2005 migration failing...
    By mullet_man in forum MIS Systems
    Replies: 13
    Last Post: 23rd November 2007, 06:03 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
  •