MIS Systems Thread, Exporting database in Technical; Does anyone know how to export the SIMS database as an mdf file so i can reinstall SIMS and attach ...
11th February 2013, 08:20 PM #1
- Rep Power
Does anyone know how to export the SIMS database as an mdf file so i can reinstall SIMS and attach the saved mdf file to it? Any help would be appreciated
11th February 2013, 08:25 PM #2
I would recommend you set yourself up an account on the Supportnet website if you don't have a logon already.
A guide will be on here after a quick search (hopefully). It's a matter of using the dbdetach and dbattach tools, but off the top of my head it may require additional steps and its been a while since I carried it out myself.
11th February 2013, 09:01 PM #3
- Rep Power
Its fairly straight forward, if you go into system manager and create a backup it will create a .BAK file,
copy this were you want to.
Install the SQL instance on your new computer then drop to the command prompt,
navigate to the location of your SQL instance,
i.e. c:\program files\Microsoft SQL Server\MSSQL10\Binn
the run DBattach /RESTOREUI
This will then run DBattach and allow you to do a full restore of the database without any loss of data.
12th February 2013, 03:36 PM #4
I would add in, that part of the install of SQL, is then the install of SIMS tools on the server. The best way to do this is to download teh installable ISO from supportnet, though i think now you have to request it from them or your support team.
This creates the folder and the binn which has dbattach in it. You should then be able to run it from the start menu. I think the new version has the restore switch added already i'm sure someone said.
Another interim step is that the version of sims installed on teh server needs to match the backup i.e. the current system, so the installable is usually spring, so you should then run the ISO which has the update files on it, this usually has a link available on SupportNet. Run the update that matches the version you are on.
e.g. install SQL, run sims spring 2012 installable, run autumn sims update. then restore data.
12th February 2013, 03:45 PM #5
- Rep Power
Was just going to add the same when I got dragged off to fix something.
If you're setting up a test SIMS system then make sure it's secured as it has all of your data in it.
Also, check your licensing with whoever does your support that you are covered to do this.
12th February 2013, 04:03 PM #6
oh yes, for test, make sure you check other threads here for best practise and more detail.
e.g. alter the docstorage settings, so they don't point to the live storage.
By NikChillin in forum Windows
Last Post: 20th August 2012, 10:59 AM
By torytechie in forum Windows Server 2008 R2
Last Post: 10th November 2010, 11:51 AM
By FN-GM in forum How do you do....it?
Last Post: 14th July 2008, 09:44 PM
By RobC in forum Educational Software
Last Post: 21st April 2006, 07:45 PM
By mrtechsystems in forum General Chat
Last Post: 28th June 2005, 10:01 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)