MIS Systems Thread, Installing a new sims server in Technical; Hi guys,
Having installed sims befor I wasn't particularly daunted by this. However as usual something awkward had to happen. ...
9th November 2011, 12:10 AM #1
- Rep Power
Installing a new sims server
Having installed sims befor 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?
9th November 2011, 01:18 AM #2
Is there anything in the event log regarding the problem with the service?
9th November 2011, 08:48 AM #3
Are u you using windows server 2008? Do you need to change the UAC to start the service as administrator?
9th November 2011, 09:05 AM #4
By 'copy', do you mean you 'detached' them and 'reattached' them?
If you just mean physically copy, then that could well be your problem.
9th November 2011, 09:35 AM #5
Did you store your log files on a different drive? If so SIMS expects them to be in the same place (why this is so is a different question). If they're not together put them together and later use SSMS to move the log file.
9th November 2011, 10:37 AM #6
Someone doesn't read the release notes do they, they sorted that little problem out
Originally Posted by Heebeejeebee
9th November 2011, 11:49 AM #7
Not well enough then because I had this just a few weeks ago
Originally Posted by matt40k
You can have the log files in a different place but in a DR situation when I went to re-attach the database(s) it wouldn't let me unless the log files were sat in the same directory.
9th November 2011, 12:32 PM #8
I think they broke it one of the version stupidly. It worked fine in one version then the next it stopped working - it still read the Log path from regkey but didn't actually use the path. I know it did work because I was able able restore\attach a backup when the paths were:
C: - SQL Apps
E: - MASTER, temp etc
F: - Data
G: - Logs
I would log it with the helpdesk anyway - they'll most likely say it's fixed in the next release however!
By fiza in forum MIS Systems
Last Post: 15th May 2011, 04:12 PM
By Ell2Cool in forum MIS Systems
Last Post: 29th October 2007, 01:21 PM
By bobwright in forum MIS Systems
Last Post: 21st June 2007, 09:49 AM
By GrumbleDook in forum MIS Systems
Last Post: 4th April 2007, 12:29 AM
By wesleyw in forum MIS Systems
Last Post: 22nd January 2007, 10:34 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)