So do you use six disk?
So do you use six disk?
Yes, there's 6 disks in total. 2 x 73GB (RAID1) for OS Install, 4 x 300GB (600GB usable RAID 10) for SQL Data Directory.
From you previous answer I guess the answer is NO, you have not actually migrated from one MIS to another.
I did check Ts&Cs the data in the database is the schools property! But just to make sure I copied the original! It is only the application accessing the data that is part of Ts&Cs. The migration procedures are run within Facility by the school.Quote:
Also Serco move the data for you
How does that fit with the Ts&Cs of your Capita contract which state, IIRC, that you won't share your database outside of your school and Capita?
Any how I guess that is not really the point of this thread, just that I seem to becoming a grumpy old **** recently!
I don't think so: http://www.microsoft.com/sql/howtobuy/default.mspxQuote:
Originally Posted by bossman
Moving data from one sims server is a doddle and will take you one day only at the most. I have just done this with mine moving from one domain to another, it took me just less than a day and then obviously now I have to visit all the workstations and reconfigure them to go onto the new domain. Not using as much RAM as you guys but see no problems with connectivity or speed. I will need to revisit this later in the year as we have more users connected to the SIMS database.
nayone know the optimal options to choose when installing? Our LEA team have given us meticulus instructions on installing SQL server but been very vague on what components are best installed. IS just the database enough or ar things like teh management and connectivity tools best to install?
I am frankly quite disgusted.
We have been told that a roadmap to sql2005 would be published. I've heard nothing from our local dotict team apart from being told that there was a tool for estimating the server specification. The tool wouldn't run, I reported the issue but have heard nothing since. Over two months now. If I'm going to need to build a new server I need a budget and plenty of time. I'll be delighted to move to sql 2005, but the time allowance is atrocious.
I have defended Capita and SIMS to our head in the past and had a fair amount of flack about it. I'm afraid I'm beginning to think that they have a captive customer base and they don't have to worry about disruption. Our school is in the middle of timetabling issues, I've got a number of major projects to oversee, there have been no announcements from our local dotict team about the August upgrade, let alone that this will require an SQL 2005 move.
I have just completed the August MIS upgrade and the Migration to SQL 2005 with no issues what so ever, took about 1.5 hrs..
Last week the LEA came in to run the August upgrade, install SQL 2005 and migrate the database over. They said to leave SQL 2000 running for a month in case there were any problems. Thinking about it I can’t see any advantage in keeping SQL2000 running as it was only used for Sims and now the database has been converted to 2005 there’s no going back. Funny that :?
Am I right in interpreting then that the SQL2005 upgrade has to be carried out before the August update?
All the literature I've been given by the support department in our LEA state that the order is August Sims upgrade, SQL2005 upgrade, then November Sims upgrade.....