MACIT Posted April 28, 2009 Posted April 28, 2009 Im looking at moving our current 2003 R2 32Bit setup over to a 2008 x64 Enterprise Server. Has anyone done this yet as so far im not getting very far. siminst runs ok but does not "see" the 64Bit install of SQL2005, All i get is a drop down option offering a 32bit instance. Any pointers appreciated?
techyphil Posted April 28, 2009 Posted April 28, 2009 yup i done it 7 days ago. Well .ICT did it for me. I moved SIMS from Win2k3 R2 32bit to Win2k8 64bit running MSSQL2005 64bit. We've got 12GB RAM installed in this box and SQL has gobbled up 10GB
matt40k Posted April 28, 2009 Posted April 28, 2009 Make sure you have the latest Setups directory (SIMSINST), install MSSQL first, then run the installer (SIMSINST). Just remember Nova-T, Exams and other old bits won't work. If you're going 64bit, you might as well get Full MSSQL otherwise you're limiting yourself to 1GB.
rasssp Posted April 28, 2009 Posted April 28, 2009 nova t and exams? both dont work on sql 2005 x64? Is that nova t 4 or 6? or both
FN-GM Posted April 28, 2009 Posted April 28, 2009 I was under the impression you would only get problems if you are actually running them on a 64 bit client. All the server holds is the database and files, you wont be running the software on there.
rasssp Posted April 28, 2009 Posted April 28, 2009 Capita have told us we may need to goto sql enterprise as our db has outgrown the standard version. Also discussing the move to 2k3 x64 and sql 2005 x64. Any one have a list of advantages and disadvantages?
matt40k Posted April 28, 2009 Posted April 28, 2009 Nova-T4 is 16bit... not checked 6... I assume 32bit. I was under the impression you would only get problems if you are actually running them on a 64 bit client. All the server holds is the database and files, you wont be running the software on there. Correct, however when you get a problem you generally want to test it on the server, first thing that springs to mind to Exams when you import results (otherwise you end up manually splitting the file up). You might also want to make your SIMS Support aware, just so they don't remote-in to the server, but the client.
matt40k Posted April 28, 2009 Posted April 28, 2009 Capita have told us we may need to goto sql enterprise as our db has outgrown the standard version. Also discussing the move to 2k3 x64 and sql 2005 x64. Any one have a list of advantages and disadvantages? 64bit will have (software) problems, however generally I (personally) find about 15% performance increase.
Theblacksheep Posted April 28, 2009 Posted April 28, 2009 Kent in particular have said they dont support 64bit.
Oops_my_bad Posted April 28, 2009 Posted April 28, 2009 Capita have told us we may need to goto sql enterprise as our db has outgrown the standard version. Any one have a list of advantages and disadvantages? I doubt very much you have a database size in excess of 4GB - we are a large school and dont even hit 900meg on DB size. Sounds like you need to tidy up your database
matt40k Posted April 28, 2009 Posted April 28, 2009 I doubt very much you have a database size in excess of 4GB - we are a large school and dont even hit 900meg on DB size. Sounds like you need to tidy up your database can't understand either how you could have 4gb or bigger DB. Must be all the nova and old profile rubbish. >2k students, 240 staff, lesson monitor etc only comes in at around 2GB.
rasssp Posted April 28, 2009 Posted April 28, 2009 we are one of the bigger schools. db is currently 3.81gb 2500 students, 350+ staff
steve Posted April 28, 2009 Posted April 28, 2009 1800 students with a 3.5Gb db Its grown from 2Gb just 18 months ago.
matt40k Posted April 28, 2009 Posted April 28, 2009 1800 students with a 3.5Gb db Its grown from 2Gb just 18 months ago. What the hell? How? Not something stupid like your sims.ldf being huuge? What modules are you using? Any 3rd party stuff?
Steve_T Posted April 29, 2009 Posted April 29, 2009 Shrink the log is a good place to start and tidy up the database, if you have been using it along time think how much dead wood you have.
steve Posted April 29, 2009 Posted April 29, 2009 We do a nightly backup that shrinks the ldf - its the mdf that's grown. SIMS is used here very intensively - all lesson registers, assessment, profiles, personnel, you name it we use it, and use it a lot.
Jobos Posted April 29, 2009 Posted April 29, 2009 Shrink the log is a good place to start and tidy up the database, if you have been using it along time think how much dead wood you have. How do you shrink the log?
steve Posted April 29, 2009 Posted April 29, 2009 From Supportnet: 1) Create a new user in SIMS .net, making them a member of the System Manager group and also a trusted SIMS .net user 2) Create a batch file containing the following DBATTACH /SERVER="server\sims" /DATABASE="SIMS" /BACKUP /AUTO /TRUSTED if ERRORLEVEL 1 GOTO :ERROR GOTO :END :ERROR ECHO NOT WORKING :END 3) Create a scheduled task to run the batch file the with the users credentials as in 1) The task will then run whether the user is logged in or not A Scheduled Task is set up via:- Start | Control Panel | Scheduled Tasks | Add Schedule Tasks Follow the on screen instructions and browse to the batch file that will run the backup
Steve_T Posted April 30, 2009 Posted April 30, 2009 As Steve said above or user SQL Management Studio it wont bite. A huge amount problems can be resolved with a few clicks using Management studio. See attachment.Shrink.bmp
Oops_my_bad Posted April 30, 2009 Posted April 30, 2009 From Supportnet: 1) Create a new user in SIMS .net, making them a member of the System Manager group and also a trusted SIMS .net user 2) Create a batch file containing the following DBATTACH /SERVER="server\sims" /DATABASE="SIMS" /BACKUP /AUTO /TRUSTED if ERRORLEVEL 1 GOTO :ERROR GOTO :END :ERROR ECHO NOT WORKING :END 3) Create a scheduled task to run the batch file the with the users credentials as in 1) The task will then run whether the user is logged in or not A Scheduled Task is set up via:- Start | Control Panel | Scheduled Tasks | Add Schedule Tasks Follow the on screen instructions and browse to the batch file that will run the backup Is there anyway to get dbattach to automatically detach the database so you can backup the actual .mdf and .ldf? I can think of a few situations where the .bak scripts would be pretty useless in the event of a restore...
matt40k Posted April 30, 2009 Posted April 30, 2009 (edited) Is there anyway to get dbattach to automatically detach the database so you can backup the actual .mdf and .ldf? I can think of a few situations where the .bak scripts would be pretty useless in the event of a restore... Just top the SQL service (net stop mssql$sims2005) copy the .mdf/.ldf then start MSSQL (net start mssql$sims2005) Yet to hear of a case where the .bak can't be used to be honest. FYI: if you do copy the .mdf etc, take a copy of master. Whilst on the subject, if you use FMS, it MUST BE BACKED UP AT THE SAME TIME AND BOTH RESTORED FROM THE SAME TIME. caps off Edited April 30, 2009 by matt40k 1
Steve_T Posted May 1, 2009 Posted May 1, 2009 MUST BE BACKED UP AT THE SAME TIME AND BOTH RESTORED FROM THE SAME TIME. Make sure you do take note of the above or you will encounter problems regarding Unsynchronised databases.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now