RobT

If it helps I have already migrated manually a schools SIMS & FMS database to SQL2012 without issue.

We also add exception for SQL database files so add do not scan *.ldf & *.mdf.

Capita are in the process of writing the documentation to move SOLUS from one server to annother. On the 22nd May I was at apresenation where Jonathan Wood from Capita briefly showed us the draft of the document but has not shared this yet. Not knowing hoe many computers had and how easy your first install was. Having spoken to a few people at this meeting including Capita engineer that they found fresh install was alot easier.

Not sure if this is the answer but we found that Trusted installers caused lots of issues with FMS when windows 7 first came out. We changed the permissions owner on the C Drive from "Trusted Installers" to "Administrators" and this resolved issues. This might be worth a look.

First Thing is to setup your backup location: Run the following from within the "setups" folder within the SIMS Folder. setsimsbackupfolder.exe /SERVER=127.0.0.1\sims2008 /DATABASE=SIMS /BACKUP_PATH="D:\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\Backup" /USER=sa /PASSWORD=******* **If not running on server that has SQL Installed then change the IP address to SQL Server. The Backup Path you specify what you want. Password is what every your sa password has been set to. FMS Backup From where every you have SQL installed the BINN Folder (this time the FMSSQL folder as it is a different dbattach file), if you are not sure check sims.ini from C:\windows. cd "C:\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\Binn\FMSSQL" DBATTACH.exe /BACKUP /AUTO /SERVER=127.0.0.1\sims2008 /User=sa /Password=******* /DATABASE=FMS ** Note change name to match database, if you have more than one FMS database then just copy the last line changing the database name. Backup of Document Storage All I have ever done is stop the service copy the folder and start the service. Here is Capita's advice Backing Up Locate the SIMS Document Management Server’s Local document storage location. This will be the location specified during installation of the SIMS Document Management Server, usually C:\Docstorage. If you do not know where the local document storage location is, there is a utility that can be used to find out. The utility is found in the directory in which the SIMS Document Management Server has been installed, usually C:\Program Files\SIMS\SIMS .net Document Server. To use the utility, you need to access DOS: 1. Select Start | Run from the Taskbar to open the Run dialog. 2. Enter command and press Enter to open the DOS Command Prompt. 3. Change directory to the location of the SIMS Document Management Server by entering e.g. cd \Program Files\Sims\SIMS .net Document Server (or wherever it is installed, including spaces) and pressing Enter. 4. Enter dmconfig /D (including the space) and press Enter to display Information about the installation of the SIMS Document Management Server. 5. This would give an example of the directory in which the Local document storage location resides e.g. C:\Docstorage. 6. Note down the details of the Protocol, Port and Directory. 7. Type Exit and then press Enter to exit DOS. 8. You can now backup the Local document storage to a suitable location, by using Windows® Explorer to copy the folder in Local Document Storage location to a backup medium or to another safe location on the network. SIMS .net Backup From where every you have SQL installed the BINN Folder, if you are not sure check sims.ini from C:\windows. cd "C:\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\Binn" DBATTACH.exe /BACKUP /AUTO /SERVER=127.0.0.1\sims2008 /User=sa /Password=******* /DATABASE=SIMS I have some VBScripts that I use to move backup so that I keep a seven day rolling backup on local server, I use this as another backup incase the main backup fails wether it be tapes or offsite backup. If you need any more help just private message me and I will be happy to help you. Rob

Have you thought of try to set then back up location using the setsimsbackupfolder.exe and just running the backup line with out the path. Example command d:\sims\sims\setups\setsimsbackupfolder.exe /SERVER=127.0.0.1\sims2008 /DATABASE=SIMS /BACKUP_PATH="D:\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\Backup" /USER=sa /PASSWORD=******* Then I would run "e:\program files\microsoft sql server\mssql10.sims2008\mssql\binn\DbAttach.exe" /BACKUP /AUTO /SERVER=127.0.0.1\SIMS2008 /DATABASE=SIMS /USER=**** /PASSWORD= ****

Thanks to all who offered help advise. I have traced the issue to Group Policy refresh frequency. Now that I have disabled this group policy it has stopped the issue.

I have installed a new NIC (Intel Pro 1000 PT Server) with the power managment switched off and still having the issue. Has anyone got any other sugguestions as I am at a lost, at moment.

I have a school that I support that has 3 sites. The main site site1 has the SIMS & FMS Server. Sites 2 & 3 are approx 6 miles away from site 1. Sites 2 & 3 have fibre between them accross some fields. Between site 1 & 3 there is a 10Mb link. I have no issues with SIMS .net or FMS across the 10Mb link. The only time there is an issue is when an update is done and all workstation are wanting to upgrade. We get round this by getting the staff to leave machines on and setting a scheduled job on each machine to run sims .net over night. To get the best performance I used IP address only and no mapped drives for SIMS .net. So in the sims.ini [setup] SIMSDirectory=\\*.*.*.*\SIMSROOT\SIMS SIMSSetupsDirectory=\\*.*.*.*\SIMSROOT\SIMS\Setups For the connect.ini (Local C Drive) [sIMSConnection] ServerName=*.*.*.*\SIMS2008 DatabaseName=sims Hope this helps, any questions message me.

I have encoutered this issue before and have found the problem was caused by groupcall. It seems that sometimes groupcall can leave a connection open to the database. To resolve this I now stop the groupcall service and then restart it after I have finished.

I have installed a Intel network card, will now have to wait for schools return to see if this resolves the issue.

@teejay: Yes migrated to SQL2008 last December. I have also detached the database and reattached database using SQL2008 Migration tool in advanced mode to make sure no issues. The original migration was done via automatic deployment script.

@theriver It is happening to multiple machines. What is so strange is that this has been a great network with nothing much changing except upgrading to 6.138 and getting the issues. Even though the server is 2003 it is still well spec Dell.

Matt Your first replay. Already done the "regional settings". I found a slightly quicker way, Go into Region and Language, then "Administrative" tab and click "Copy settings", then at the bottom put a tick in "Welcome screen and system account" + "New Users". The ping test is fine both on wired and wireless. I have had one laptop running on wired and the other on wireless. When the problem occurs it happens on both machines at the same time which is pointing to me as if a server/network issue not workstation. Your second replay. Yes I had found that KB on Microsoft website and have already applied. The Server is fully serviced packed and all updates applied. I have looked at just about every think I can thinks from changing windows update times to sophos AV scans. The main problem is there is no patter to it. Can happen one time one day and then go few days no issue. Then another day it can happen 10 times. I also run network diag and left them running so see if I could capture an issue. Apart from this issue the schools network runs sweet. Any other suggestions would be useful. My next step if nobody can help is to upgrade them to 6.140 and see what happens. I am also going to upgrade there spare windows xp laptop and run that side by side with windows 7 machines. Thanks for you suggestions.

SQL Native Client error Common link Failure with FMS 6.138. I have a school that have Server 2003 & windows 7 laptops. They are getting intermittent issue where it sates "You have altered your system clock. It strongly recommended that you re-start module in order to ensure client/server system date/time integrity." Both the server & workstation time are same. Regional settings are all set correctly. Even reset the faults on the windows 7 laptops. There is no time syncs going on the network. I have looked at "General Network error," "Communication link failure," or "A transport-level error" as per Error message when an application connects to SQL Server on a server that is running Windows Server 2003: "General Network error," "Communication link failure," or "A transport-level error". Still no resolved. Logged call with Capita and this was given the following rubbish response:- ================================================================ Activity Date: 20/07/2011 10:31:22 Communication Type: E-mail Activity by: Bradley Cotton Emailed Customer Hi Rob, I have spoken to a colleague regarding this issue. Unfortunately there is nothing that can be done with this issue as it is an intermittent issue. The same issues occur when running FMS over a virtual machine. Apologies for any inconvenience caused.

We often keep a copy of the setups from the old server but always start with a fresh setups based on the last Main release.

Mark I see lots of issue fixed on windows 7 with SIMS & FMS and the problem been down to the owner of the files. We now change the owner of files in the C Drive from "Trusted Installers" to "Administrators". Since doing this on new Windows 7 PC we have seen the number of support calls for windows 7 machine drop. This might be of help to you.