Windows Server 2000/2003 Thread, SIMS problems in Technical; Just trying something out at present.
I have install server 2003 on a machine that I had spare & I ...
18th November 2010, 12:33 PM #1
Just trying something out at present.
I have install server 2003 on a machine that I had spare & I want to install SIMS on to it so that it acts as a SIMS server, so that I can test the backup database files are working correctly etc.
I have installed the Spring 2010 CD & I think I am now running on the summer version, but when I want to attach the backup database I get an error message that the version I am using is 10.00.2531 & the server the database came from is running version 10.50.1600
What doI need to do to sort this out? Any help much appreciated. If I need to re-install everything that is not a problem. I have attached the message as a jpeg.
IDG Tech News
18th November 2010, 01:17 PM #2
How are you creating the backup?
18th November 2010, 01:35 PM #3
I'd say that your server is SQL Server 2008 R2, and you're trying to restore to SQL Server 2008.
18th November 2010, 03:26 PM #4
Agreed, which version of SQL are you trying to put this onto?
18th November 2010, 11:15 PM #5
Never thought of that. On the main SIMS server I think it is SQL 2008 R2. The one I am trying it on is 2008 express. I don't suppose there is a way to get the express version to recognise the database without installing SQL 2008 R2. Any suggestions?
19th November 2010, 10:06 AM #6
You can try (and I stress try!) installing SIMS as a fresh install on your new server, forget the old for the moment. Then using SQL, not the SIMS tools, backup the original copy the backup to the new server, and again using SLQ tools, restore the database. The same could be done detaching the original, copying the mdf and ldf files, and attaching these copies to the new server (remember to reattached the originals!!!).
The former would be the preferred, and somewhat safer option.
23rd November 2010, 01:17 PM #7
Still got this problem even though I have installed SQL server 2008 R2. I thought that may sort it.
Any other suggestions? I can only think that the server is not working on the latest version of SIMS, but how can I check this. I used the Spring CD to install & have uploaded the latest files from the working server. How can I get it to the summer release?
I need to get on a course, but very busy at present to do this.
23rd November 2010, 02:43 PM #8
Did you copy the entire sims application folder across i.e. s:\sims? (im guessing you have) did you run the sql setup and sims setup files from there?
23rd November 2010, 07:54 PM #9
No I have only copied the sims/setups folder. Do I need the complete sims folder?
24th November 2010, 12:48 PM #10
Have you run the SIMSSQLApplicationSetUp.exe file? That will need doing. The entire folder should not be needed, as long as you have the setup and the database, everything else is created for you (other than the data in SNOVA folder obviously!).
24th November 2010, 02:02 PM #11
As GREED says, you dont need the entire folder, i was wondering what you did copy.. you do need to run the setup files tho.
Originally Posted by kestrel1
24th November 2010, 03:01 PM #12
Yes the SIMSSQL application setup has been run.
What is the error message actually referring to when it says that the version of the database is 10.50 & the server is 10.00
Failing this, does anyone have a guide to installing a SIMS server? Not found anything of any use on SupportNET.
24th November 2010, 03:35 PM #13
If you can wait until this evening when I get home I can give you the one I made ages ago, it seemed popular at the time!
PM me your email address and I can send it to you, but will also copy the text to here (if someone would like to point out a more suitable place... nudge admins/mods)
24th November 2010, 04:08 PM #14
Ooops should have paid more attention to the version number you quoted.. its saying you have a different version of SQL 2008 i.e. 10.00 is SQL 2008 and 10.50 is SQL 2008 R2.
Originally Posted by kestrel1
Which version of express do you have?
Last edited by apeo; 24th November 2010 at 04:19 PM.
24th November 2010, 06:00 PM #15
Originally I was using the original version but then installed R2. I am going to do a clean install & follow Greeds instructions on installing & see how I get on.
I thought it may be the SQL version number but wasn't sure. So much to learn, so little time to do it
I will post how I got on once I have completed the tasks.
Many thanks to all who have helped.
By LosOjos in forum MIS Systems
Last Post: 19th March 2010, 01:08 PM
By dave20046 in forum Windows
Last Post: 25th February 2009, 12:13 PM
By GILLSMITH23 in forum MIS Systems
Last Post: 5th December 2008, 04:46 PM
By Simcfc73 in forum MIS Systems
Last Post: 16th April 2008, 10:45 AM
By sallyb in forum MIS Systems
Last Post: 9th December 2007, 10:23 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)