MIS Systems Thread, Help Please june Update + sql2008 in Technical; well Ive just tried to do the June Upgrade on my test system running SQL2008/sp1 and the march version of ...
6th July 2009, 10:49 AM #1
Help Please june Update + sql2008
well Ive just tried to do the June Upgrade on my test system running SQL2008/sp1 and the march version of sims
And it's not playing:
reading supportnet you need solus "2.whatever" But the version thats on the ISO is ver 1.19
the install keeps failing with backup failed no_log not supported
I cant find docs on supportnet to help and since there fix for locked backups only applies to sql 2005 im stuck
Anybody got any ideas?
6th July 2009, 10:55 AM #2
- Rep Power
SIMS has a problem with locking the database at the moment, and it fails on the backup. To get around the problem you currently need to put the database into single user mode to perform upgrades. Capita have a fix available (I'm installing it tomorrow).
6th July 2009, 10:55 AM #3
SIMS doesn't support SQL 2008, that's your first problem, so no reason it would work.
As for the error... Have you got transaction logging turned off?
6th July 2009, 10:58 AM #4
- Rep Power
Good point Diello. 2008 not officially supported until later this year, but I have assumed that upgrades have worked on your test system before?
6th July 2009, 11:16 AM #5
yep march 09 runs fine on sql2008
will have to try locking sql to single user will report back soon...
I know i would not want to be having to jump straight to sql2008 without testing it first ....
6th July 2009, 11:21 AM #6
nope single user didnt work...
looks like im taking sql2008 off and reinstalling my test rig
6th July 2009, 01:51 PM #7
Why would you test something before it's supported? There basically saying it won't work lol!
6th July 2009, 03:26 PM #8
i was looking at the work that i might have to do over the holidays no biggie will just go back to 2005
but it would have been nice to have 6 weeks to play with sims on sql 2008 rarther than just having it dumped on us in october...
teach me to planm ahead....
By meastaugh1 in forum MIS Systems
Last Post: 28th August 2008, 09:55 AM
By skunk in forum MIS Systems
Last Post: 1st August 2008, 01:28 AM
By PRicho in forum MIS Systems
Last Post: 30th June 2008, 10:50 AM
By elsiegee40 in forum Educational IT Jobs
Last Post: 6th June 2008, 07:34 AM
By sLiDeR in forum Windows
Last Post: 1st April 2008, 10:01 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)