+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Restore FMS database in Technical; Hi, I've been asked to perform a restore of FMS database. This is just to see that it can actually ...
  1. #1

    Join Date
    Sep 2005
    Location
    W. Cumbria
    Posts
    89
    Thank Post
    15
    Thanked 3 Times in 3 Posts
    Rep Power
    18

    Restore FMS database

    Hi,

    I've been asked to perform a restore of FMS database. This is just to see that it can actually be done and has been requested by SMT.
    I've been in touch with a colleague who has suggested that I stop SQL, copy the ldf/mdf files and then detach the database and then reattach.

    We do have SQL Management Studio Express installed which seems a much easier method but I hear there are issues with usernames and passwords.

    Annoying there seems to be no documentation on it (from what I can see)

    Are there any issues I should be aware of before going ahead?

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,343
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    You need to recover from a backup? Or do a test restore?

    Basically, there is a known issue with the backup not having the user creds, they are stored in the MASTER and they should be backed up into the .bak file.

    Assuming the masters is still the same, ie you don't move servers, you should be able to run dbattach with the /restoreui switch fine. Make sure you use the FMS dbattach (mssql\binn\fmssql\dbattach) not the SIMS one (mssql\binn\dbattach).

    If you want to ensure the backup contains the user creds, deattach, reattach etc tents to work, there is however, a /masters swich for dbattach, which will backup the MASTER db and there is a nice SQL statement to ensure the creds are inserted into the .bak.

    Hope that helps.

    EDIT:

    Also be aware that SIMS and FMS "talk" and therefore they must be restored\backup at the same time. Unless you want to pay Capita .
    Last edited by matt40k; 16th June 2009 at 11:16 AM. Reason: Updated - FMS\SIMS

  3. 2 Thanks to matt40k:

    Outpost (16th June 2009), SeanVin (23rd December 2009)

  4. #3

    Join Date
    Sep 2005
    Location
    W. Cumbria
    Posts
    89
    Thank Post
    15
    Thanked 3 Times in 3 Posts
    Rep Power
    18
    Thanks matt40k,

    On your last sentence,
    Also be aware that SIMS and FMS "talk" and therefore they must be restored\backup at the same time. Unless you want to pay Capita .
    are you saying I need to restore FMS and Sims together?

  5. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,343
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    Quote Originally Posted by Outpost View Post
    Thanks matt40k,

    On your last sentence,

    are you saying I need to restore FMS and Sims together?
    Yes, you can normally get away with it, I'm not sure the exact details, I've not tested it much. I know it's something to do with the flags in FMS and P7 (SIMS). Have a look at KB62503, if that doesn't work, you generally have to send the data off to Capita to have the flags reset.

  6. #5

    Join Date
    Sep 2005
    Location
    W. Cumbria
    Posts
    89
    Thank Post
    15
    Thanked 3 Times in 3 Posts
    Rep Power
    18
    Just found this

    KB72855 on FMS restore. Posted for others in case its useful.

    Thanks again matt40k

SHARE:
+ Post New Thread

Similar Threads

  1. FMS installable \ FMS installer
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 5th March 2009, 01:01 PM
  2. 2003 DC restore using acronis true image with universal restore
    By ranj in forum Windows Server 2000/2003
    Replies: 2
    Last Post: 8th February 2009, 05:50 PM
  3. Attaching FMS Database
    By mloveless in forum MIS Systems
    Replies: 0
    Last Post: 3rd June 2008, 03:39 PM
  4. Restore sims database
    By zag in forum MIS Systems
    Replies: 4
    Last Post: 8th April 2008, 10:39 AM
  5. DHCP restore database
    By timbo343 in forum Windows
    Replies: 3
    Last Post: 11th January 2008, 07:08 PM

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
  •