+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, FMS backup question in Technical; Our SQL server has decided to take a massive dump today. The raid is gone, the SCSI card is kaput ...
  1. #1

    Join Date
    May 2006
    Thank Post
    Thanked 10 Times in 5 Posts
    Rep Power

    FMS backup question

    Our SQL server has decided to take a massive dump today. The raid is gone, the SCSI card is kaput and our backups have apparently been quite happily creating garbage backup files for the past 4 days.

    Going back to the most recent backup, the full server backup, (bkf) file is corrupted. We do have the latest sims db backup (created using dbattach),
    and were wondering if we rebuilt the server, reinstalled sql + sims, and FMS, if copying back and reattaching the lastest sims db backup would be enough.

    We were migrated to SQL FMS a few months ago.

    Does the backup created using dbattach, backup the FMS information as well?

    Also, if someone could point me towards some SIMS install documents, that would be really appreciated.

    Thank you

  2. #2

    teejay's Avatar
    Join Date
    Apr 2008
    Thank Post
    Thanked 796 Times in 605 Posts
    Rep Power
    The fms data is held in a separate sql database usually called ccsfms, so if your dbattach backup was just backing up the sims database then no you won't have the fms data.

  3. #3
    apeo's Avatar
    Join Date
    Sep 2005
    Thank Post
    Thanked 115 Times in 111 Posts
    Rep Power
    You will also need the backups to match i.e. the backup for sim db and fms db should be at the same time or there will be sync issues (so i have been told).

+ Post New Thread

Similar Threads

  1. nt backup question
    By strawberry in forum Windows
    Replies: 1
    Last Post: 25th May 2008, 02:34 AM
  2. FMS question, for those that run it
    By wagnerk in forum MIS Systems
    Replies: 7
    Last Post: 24th January 2008, 10:47 AM
  3. NT Backup Question
    By TechSupp in forum How do you do....it?
    Replies: 5
    Last Post: 30th July 2007, 08:38 AM
  4. Backup Tapes Replacement & Backup Schedules
    By robknowles in forum Hardware
    Replies: 2
    Last Post: 18th April 2007, 11:55 PM
  5. Replies: 9
    Last Post: 1st August 2006, 11:25 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