[sims] Installing a new sims server

[boolyn]

Hi guys,

 

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?

 

Thanks

Dave

[FN-GM]

Is there anything in the event log regarding the problem with the service?

[pubgrub277]

Are u you using windows server 2008? Do you need to change the UAC to start the service as administrator?

[Guest salan]

By 'copy', do you mean you 'detached' them and 'reattached' them?

If you just mean physically copy, then that could well be your problem.

Alan

[Heebeejeebee]

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.

 

HBJB

[matt40k]

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.

 

HBJB

 

Someone doesn't read the release notes do they, they sorted that little problem out

[Heebeejeebee]

Someone doesn't read the release notes do they, they sorted that little problem out

 

Not well enough then because I had this just a few weeks ago

 

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.

 

HBJB

[matt40k]

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!