+ Post New Thread
Results 1 to 6 of 6
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 ...
  1. #1

    Join Date
    Apr 2012
    Location
    Huddersfield
    Posts
    90
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Blog Entries
    1
    Rep Power
    0

    Question Exporting database

    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

  2. #2

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,268
    Thank Post
    380
    Thanked 388 Times in 343 Posts
    Rep Power
    150
    I would recommend you set yourself up an account on the Supportnet website if you don't have a logon already.

    http://support.capitaes.co.uk/newlogin/login.asp

    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.

  3. #3
    staningrimsby's Avatar
    Join Date
    Jan 2013
    Location
    Grimsby
    Posts
    143
    Thank Post
    5
    Thanked 4 Times in 4 Posts
    Rep Power
    4
    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.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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.

  5. #5

    Join Date
    Jan 2007
    Posts
    101
    Thank Post
    0
    Thanked 35 Times in 24 Posts
    Rep Power
    22
    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.

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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.



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 11
    Last Post: 20th August 2012, 10:59 AM
  2. exporting the Active Directory Database
    By torytechie in forum Windows Server 2008 R2
    Replies: 9
    Last Post: 10th November 2010, 11:51 AM
  3. Automate a Database Export to a schedule
    By FN-GM in forum How do you do....it?
    Replies: 10
    Last Post: 14th July 2008, 09:44 PM
  4. Technical Databases
    By RobC in forum Educational Software
    Replies: 15
    Last Post: 21st April 2006, 07:45 PM
  5. Database with a Barcode Reader
    By mrtechsystems in forum General Chat
    Replies: 5
    Last Post: 28th June 2005, 10:01 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •