+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Verify Backup in Technical; Simple one really. How do you verify your SIMS/FMS databases have backed up correctly? Thanks, Dan...
  1. #1

    bladedanny's Avatar
    Join Date
    May 2009
    Location
    Sheffield
    Posts
    1,268
    Thank Post
    188
    Thanked 298 Times in 224 Posts
    Rep Power
    130

    Verify Backup

    Simple one really. How do you verify your SIMS/FMS databases have backed up correctly?

    Thanks,

    Dan

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    How do you backup SIMS in the first place? Stop MSSQL copy the files, or dbattach or other?

  3. #3

    bladedanny's Avatar
    Join Date
    May 2009
    Location
    Sheffield
    Posts
    1,268
    Thank Post
    188
    Thanked 298 Times in 224 Posts
    Rep Power
    130
    I use DBattach via cmd line on a scheduled task. It's creating the .bak file ok. I also know in theory how to restore from this file. I just need to know if it has worked ok.

    My first thoughts are to try and install SIMS on a VM that's seperate from out main network and try the restore. Would this be feasible?

    Thanks,

    Dan

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Could do, create a xp VM, ask for the latest installable media. Then run dbattach with the /restoreui and copy over docstorage etc.

    Won't be perfect, but should be ok for a test.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    i would make a proper vm for testing purposes. it's always useful to test out the upgrades before going live, incase it's going to break something in your setup.
    i even have a copy of the doc storage there. you just have to be careful with naming and connections so the two paths don't cross. i usually use a different mapped drive, and only log into the virtual box locally.

  6. Thanks to vikpaw from:

    bladedanny (17th January 2011)

  7. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    I think Cornwell LA have a "mirror" setup for that sole purpose. Basically backups the live database daily, restores onto the other database database

SHARE:
+ Post New Thread

Similar Threads

  1. VSS backup options and multiple backups - copy or full backup?
    By ianh64 in forum Windows Server 2008 R2
    Replies: 4
    Last Post: 21st January 2011, 02:00 PM
  2. Replies: 4
    Last Post: 26th July 2010, 02:23 PM
  3. AD : Windows cannot verify that the user name is unique
    By theeldergeek in forum Windows Server 2000/2003
    Replies: 2
    Last Post: 17th November 2009, 11:17 AM
  4. Replies: 4
    Last Post: 3rd November 2009, 01:05 AM
  5. Replies: 5
    Last Post: 17th August 2007, 03:52 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
  •