tmcd35 Posted July 19, 2013 Posted July 19, 2013 just think of a standsrd folder name, say, nobackup, then get the staff to always save stuff they do not want backed up inside a folder they call nobackup. Then get the backup software to backup any folders named nobackup anyway. fixed
Koldov Posted July 19, 2013 Author Posted July 19, 2013 Yeah, thing is I inherited this set-up and I haven't been here long enough to start telling people what to do (I know there are ways and means and it will happen). They have home folders, they have shared drives, but one or two old skool colleagues prefer to use their local pc to store their data on the desktop and such as it's easier for them. Sooooooo.... I read some post where someone above has done 7 network/server/SIMS installs in the last year... Is there a definitive guide on how to transfer SIMS from one server to the other that someone could link me to? Kol.
edutech4schools Posted July 19, 2013 Posted July 19, 2013 When i get chance (weekend) i will post some steps. 1
edutech4schools Posted July 22, 2013 Posted July 22, 2013 Ok. My method of installing SQL 2008r2. run installer click new install In features I select database engine features client tools connectivity client tools backwards compatibility management tools basic management tools complete next (if you wanted you could just select all for the above features) select named instance and type in SQL2008 (if installing sql2008 or sql200r2) instance id = SQL2008 instance root = (I choose d:\program files\Microsoft SQL server) next service accounts = choose an account on the server that will run the services. I choose NT Authority/system. If you can not select what you need just skip this and add the service accounts later in services.msc next account provisioning = I choose mixed and type in an SA password and add an administrator in the bottom box. next think that is about it 1
chazzy2501 Posted July 22, 2013 Posted July 22, 2013 Oh how lucky you are!! It normally goes like this... School: hey my pc broken, can you get all my files off it? IT: Ok, just this once but you should save it to the network so it gets backed up. [Few months pass] School: Hey the backups are failing. IT: OK lets have a look, mmm, why do you have 30GB of photos in your home drive? School: Oh, it's the photos from the school trip IT: Oh ok, what you need to do is transfer them onto your PC, then resize them then put the cut-down version on the network - and remove the duff ones - like the 90 pics of peoples hands [Few months pass] School: My PC died and I've got a load of photos on it I want off IT: I thought I said to save them onto the network? School: It took too long to crop them and resave them so I didn't bother. I gave them this tool:http://www.realfiletools.com/free/photo-resize.htm They can actually use it, (if they don't I do it for them on the server ((all 1MB)
edutech4schools Posted July 22, 2013 Posted July 22, 2013 (edited) Part2 Moving the database make sure all is backed up. copy documentstorage to new server and change folder names under documantstorage root to new setup names. create Sims folder on server map s drive to sims copy Sims folder from old server to new sims folder on server run Simsinst on new server install sims on server, choosing SQL2008 as the instance on old server open dbattach and login detach Sims database copy Sims MDF and LDF files found in d:programfiles\sql….data to new server run dbattach on new server attach Sims files change Sims.ini files to reflect new sims server on clients change c:/windows sims.ini to reflect new server. Think thats about it. Edited July 22, 2013 by edutech4schools 1
Koldov Posted July 22, 2013 Author Posted July 22, 2013 Thanks so much for this! I know this is a big ask, but have you ever done FMS and it is the same procedure? Kol.
edutech4schools Posted July 22, 2013 Posted July 22, 2013 FMS is almost the same but easier as you do not need to worry about documentstorage folder. post back if you have any issues.
edutech4schools Posted July 22, 2013 Posted July 22, 2013 UPDATE: The above SQL install info is based on the full SQL software and not the express version.
Koldov Posted July 22, 2013 Author Posted July 22, 2013 UPDATE: The above SQL install info is based on the full SQL software and not the express version. Cool. We are on an EES agreement (including SQL server) do you know which SQL package I should download from the MVLS site to put on a plain 2008 server? Kol.
Koldov Posted July 22, 2013 Author Posted July 22, 2013 (edited) Also this.... "We have also reviewed our support for SOLUS 2 and have extended use of SOLUS 2 for SIMS deployment until Autumn 2013. The last SOLUS 2 compatible SIMS release will now be Summer 2013." I'm guessing SOLUS 3 is just a download from somewhere? Kol. Edited July 22, 2013 by Koldov
tmcd35 Posted July 22, 2013 Posted July 22, 2013 "The last SOLUS 2 compatible SIMS release will now be Summer 2013." Crap, there goes my Christmas
memo512 Posted July 23, 2013 Posted July 23, 2013 Also this.... "The last SOLUS 2 compatible SIMS release will now be Summer 2013." Don't think so SOLUS2 support has been extended 2 releases to include Spring 2014. SupportNet Resource id: 17910 1
Koldov Posted July 23, 2013 Author Posted July 23, 2013 Don't think so SupportNet Resource id: 17910 Hmmmmmm.... Well I'm not signed up to the Capita Support Net, I got mine from here: http://www.capitaess.co.uk/home/SIMS_TechnicalRoadmapResourceNo17910.pdf Not sure why it's different, annoying though. Kol.
Koldov Posted July 29, 2013 Author Posted July 29, 2013 Just got a warning about installing SQL Server 2008R2 on a Domain Controller... Does anybody run this config and are there really any issues? Kol.
nickbro Posted July 29, 2013 Posted July 29, 2013 We run SQL Server 2008R2 on a 2008R2 DC, and we have no issues 1
edutech4schools Posted July 29, 2013 Posted July 29, 2013 yep, all the schools in my county run sql on the domain server. 1
matt40k Posted July 29, 2013 Posted July 29, 2013 Most primary schools do, it's just a warning - basically it's not Microsoft best practice, still it's rare you can meet all the best practices. I think it's due to the DC having more rights, so SQL would have more rights then on a member server. The other issue would is performance - kinda like running Exchange and MSSQL together but no where near as bad. Ironically, Microsoft will happily sell your Windows Server Small Business that gives you Exchange, MSSQL, DC and a butt load of other roles all on one box - I think it needs 12GB ram or something stupid however
Koldov Posted July 29, 2013 Author Posted July 29, 2013 (edited) Part2 Moving the database make sure all is backed up. copy documentstorage to new server and change folder names under documantstorage root to new setup names. create Sims folder on server map s drive to sims copy Sims folder from old server to new sims folder on server run Simsinst on new server install sims on server, choosing SQL2008 as the instance on old server open dbattach and login detach Sims database copy Sims MDF and LDF files found in d:programfiles\sql….data to new server run dbattach on new server attach Sims files change Sims.ini files to reflect new sims server on clients change c:/windows sims.ini to reflect new server. Think thats about it. I know these are probably really dumb questions, but I don't want to muck this up! Could you elaborate on the bits in blue: 1) and change folder names under documentstorage root to new setup names. Where do I do this? 2) copy Sims folder from old server to new sims folder on server Do I have to do the whole folder (S:\ drive) for historical purposes? As this SIMS server has been running for years and has so much cr*p in it from installs and updates and I would have liked a clean fresh folder structure. There are SIMS folders, inside SIMS folders, inside SIMS$ folders and it's really messy. 3) install sims on server, This will kill you I know, but I am choosing SIMS SERVER in the setup options right? It's just that some work I had to do recently on data collection for the LEA required me to log in on the server as a client... 4) change Sims.ini files to reflect new sims server This is the Sims.ini in the Sims folder on the server? Then just run FMS setup, detach on old server, copy across FMS database MDF and LDF files found in d:\programfiles\sql….data to new server? Thanks in advance. Kol. Edited July 29, 2013 by Koldov
Rawns Posted July 29, 2013 Posted July 29, 2013 I know these are probably really dumb questions, but I don't want to muck this up! Could you elaborate on the bits in blue: 1) and change folder names under documentstorage root to new setup names. Where do I do this? On the old server, the doc storage would be stored somewhere like C:\DOCSTORAGE\\SIMS2008\SIMS Once copied to the new server, the needs changing to the new server name. 2) copy Sims folder from old server to new sims folder on server Do I have to do the whole folder (S:\ drive) for historical purposes? As this SIMS server has been running for years and has so much cr*p in it from installs and updates and I would have liked a clean fresh folder structure. There are SIMS folders, inside SIMS folders, inside SIMS$ folders and it's really messy. Unless you know exactly whats current and are happy to sort it out, I would copy the complete folder. Better to be safe than sorry. 3) install sims on server, This will kill you I know, but I am choosing SIMS SERVER in the setup options right? It's just that some work I had to do recently on data collection for the LEA required me to log in on the server as a client... Yes, run SIMSINST.EXE from the setups option and choose "This device will be a SIMS server. 4) change Sims.ini files to reflect new sims server This is the Sims.ini in the Sims folder on the server? Then just run FMS setup, detach on old server, copy across FMS database MDF and LDF files found in d:programfiles\sql….data to new server? Thanks in advance. Kol. The SIMS.INI is in the Windows directory on every SIMS/FMS workstation. If the entry in the SIMS.INI file for the Setups folder location points to the old servers UAC path (\\\SIMSAREA$\SIMS\SETUPS) rather than the mapped drive (S:\SIMS\SETUPS), you'll need to update this on every workstation. FMS is almost the same. Detach the DB, copy across, attach to the new SQL instance on the new server, install the FMS client on the server and test. If you point FMS directly to the server than a redirect, you will need to manually update the FMSConnect.ini files on all of your FMS workstations. 1
Koldov Posted July 29, 2013 Author Posted July 29, 2013 (edited) On the old server, the doc storage would be stored somewhere like C:\DOCSTORAGE\\SIMS2008\SIMS Once copied to the new server, the needs changing to the new server name. Thanks for your help I kind of got it needs to be changed, I'm just not sure where exactly I am changing it? On the old server it's in a seperate folder called 'HOME', not in the SIMS folder at all. So I have replicated this on the new server and copied the contents across. But where exactly am I changing it? In the the SIMS installation? Thanks again. Kol. Edited July 29, 2013 by Koldov
Rawns Posted July 30, 2013 Posted July 30, 2013 (edited) On the old server, the doc storage would be stored somewhere like C:\DOCSTORAGE\\SIMS2008\SIMS Once copied to the new server, the needs changing to the new server name. Thanks for your help I kind of got it needs to be changed, I'm just not sure where exactly I am changing it? On the old server it's in a seperate folder called 'HOME', not in the SIMS folder at all. So I have replicated this on the new server and copied the contents across. But where exactly am I changing it? In the the SIMS installation? Thanks again. Kol. I'm not quite sure what you mean. You run SIMSInst.exe and choose the "This computer will be used as a SIMS document server" option. Point the SIMS folder and SIMS Setups folder to their respective locations and then set up your DMS: The SIMS Document storage path is where your DMS files will be kept, the default location is C:\DOCSTORAGE. It automatically creates the full folder tree during install (C:\DOCSTORAGE\\\) Usually, you would have copied the folder over already from the old server to this location. The folder that is named after the computer once copied gets renamed. Once installed, in SIMS .net, go to Tools | Setups | Document Management Server and update the computer name in there too so it points to the new server. Once done, save and test. if it comes back as passed, your DMS will be working. Edited July 30, 2013 by Rawns 1
Koldov Posted July 30, 2013 Author Posted July 30, 2013 (edited) Awesome! Thank you Just needed that clarification! In the original procedure changing the folder is one of the first things on the list, before even installing SIMS and I didn't know anything about document storage so it confused me a little. I've never installed a SIMS server, only clients. Kol. Edited July 30, 2013 by Koldov
Koldov Posted July 30, 2013 Author Posted July 30, 2013 (edited) Whoops! How can I get a new SIMS installer? It appears mine is a bit out of date... I can't select my SQL instance on the set-up page and it kicks me out when trying to install MSSQL2000 - anybody have any ideas if this is the reason it's failing and why I can't select my SQL2008R2 instance? Kol. Edited July 30, 2013 by Koldov
Rawns Posted July 30, 2013 Posted July 30, 2013 Whoops! How can I get a new SIMS installer? It appears mine is a bit out of date... I can't select my SQL instance on the set-up page and it kicks me out when trying to install MSSQL2000 - anybody have any ideas if this is the reason it's failing and why I can't select my SQL2008R2 instance? Kol. If it's trying to install SQL200 for you, then yes, it really is out of date! Sounds like you need the latest SIMS Infrastructure package. You can request it from your support unit and they can release it to you in SOLUS2 along with the SIMS Summer release.
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