Zammo Posted January 2, 2015 Posted January 2, 2015 Hello all I am attempting to migrate our SIMs database from SQL 2008 to SQL2012 I have installed the new SQL2012 instance in preperation, ran through the wizard and started the migration. However after about 15mins it fails and rolls back with the message: Backup SIMS Database Failed: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding I have tried: Using both windows and SQL Native authentication, both pass the tests in the tool fine Restating the server Double checked there are no connections from SIMs clients Performing a manual backup of the SIMs database first Setting the timeouts in SQL server management to '0' (no timeout) There is no firewall or antivirus on the server to interrupt the program The event viewer gives no real clues I am very frustrated, so any help would be hugely appreciated! Thanks Martin
Zammo Posted January 3, 2015 Author Posted January 3, 2015 Yes, many times. Although if there is an "order" I should restart some services that anyone knows of, that might help...?
Boredguy Posted January 3, 2015 Posted January 3, 2015 Have you been able to manually backup the SIMS database to rule out if it is the migration tool that is the issue. Worse case you can use DBattach to manually migrate the DB, which is what Capita Support nearly had to do for our FMS migration to 2014 just before Christmas.... but a SQL service restart fixed our issue (other than FMS logins getting purged of course =/)
Hardeep_Sco Posted January 6, 2015 Posted January 6, 2015 Zammo, Not sure if you have already checked this, but, I had this problem a while back. The database kept locking and I could get it back online, Good job I had backups. I entered in the CommandTimeOut=1000000000 into the connect.ini file and this resolved the issue. 1
Ghostgame Posted January 6, 2015 Posted January 6, 2015 Check what logon the SQL Server is running on. Change it to the Local System account, restart and see if that works.
edutech4schools Posted January 6, 2015 Posted January 6, 2015 In sql manager is the database set to simple or full?
Kellie Posted January 7, 2015 Posted January 7, 2015 I have had this at a school - Had Capita connected and they couldn't fix it or tell me why. So ended up just migrating manually.
basicchannel Posted February 16, 2015 Posted February 16, 2015 Just re-opening this thread to check if anyone had migrated SIMS from SQL svr 2008 r2 -> 2012 using the SIMS migration tool successfully? I was sent the tool a while back along with an email from support pretty much saying: 'Here is the migration tool. I haven't tried this myself but apparently it's supposed to be pretty straightforward' Basically my understanding is that SQL 2012 can be installed alongside 2008 and the migration tool will take care of shifting the dbs? Thanks
Hardeep_Sco Posted February 16, 2015 Posted February 16, 2015 I am currently Migrating 2 Schools now. The tool is very easy to use. The only issue I seem to have is with FMS. I seem to have to delete the FMSconnect.ini file and create it again for it to Pick up the FMS database. And sometimes with discover. But I have gotten around the issues. Also Schools that use Solus 3, there is currently no migration tool for the database and you will have to manually move that across.
Boredguy Posted February 16, 2015 Posted February 16, 2015 Moving the Solus 3 database is easy enough, and actually has instructions in the Solus admin handbook. 1
Hardeep_Sco Posted February 16, 2015 Posted February 16, 2015 (edited) I am struggling at the mo with Solus 3. What do you use to make a backup of Solus 3? What I have had to do is detach the database from Solus 3, Copy the database, put it in the 2012 Instance. Then attach both to 2008 and 2012 respectively. Then confirm manually. The instructions from capita in the document from 62 do not work. Any Ideas? Edited February 16, 2015 by Hardeep_Sco
Boredguy Posted February 16, 2015 Posted February 16, 2015 We have SQL 2008 Management Studio installed on the server, and that happily backed up the Solus Database, and then connected to the 2014 instance so I could restore it back. In S3 I turned off deployment, Backed up database, Created the new blank database and then restored the backup to it, updated S3 settings so it knew it was looking to SQL2014 and then turned on deployment again. 1
Hardeep_Sco Posted February 16, 2015 Posted February 16, 2015 (edited) Why I have backed it up with 2008 and restored it with 2012 it says that the database is in use. Result Sorted it. But after restoring do you still have to manually change the DB Settings under Targets | Servers? Edited February 16, 2015 by Hardeep_Sco
basicchannel Posted February 16, 2015 Posted February 16, 2015 Just realised the SIMS migration tool i was sent is actually to 2014 not 2012.
Boredguy Posted February 16, 2015 Posted February 16, 2015 Yes you have to make sure that the targets are set to the new instances manually. 1
basicchannel Posted February 17, 2015 Posted February 17, 2015 Man this is a right PITA. So I have to create a new instance name and change all DB paths so they point to the new name?
Boredguy Posted February 17, 2015 Posted February 17, 2015 Assuming you have migrated the Solus 3 database as per page 51 of the "Solus 3 Installation and Configuration Guide" Go into Solus 3 Click on Settings -> Solus 3 Make sure that your Database Instance now has your new value showing (for us we changed it from sims2008 to sims2014) & Click Save Click on Environment -> Targets -> Databases Make sure you edit the SIMS, FMS and Discover so that the server\instance now shows your new one Click on Environment -> Configure Workstations Make sure that your Connect.ini, and fmsconnect.ini have your new server\instance values Takes about 5 minutes to do the migration from start to finish.
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