+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, Backing up SIMS with Windows Server 2008 Backup in Technical; At the moment we use BackupAssist to backup our SIMS installation but the server that does this is a bit ...
  1. #1
    mrforgetful's Avatar
    Join Date
    May 2006
    Posts
    1,639
    Thank Post
    7
    Thanked 15 Times in 15 Posts
    Rep Power
    23

    Backing up SIMS with Windows Server 2008 Backup

    At the moment we use BackupAssist to backup our SIMS installation but the server that does this is a bit flaky.

    We recently moved SIMS onto a new MS Windows Server 2008 installation and I was thinking of using the inbuilt backup software in that to do the backup to a locally attached drive to remove every night.

    Does anyone know if the inbuilt backup stuff would backup everything alright? I'd just be checking the 'Backup Everything on this Server' option.

    We use it on our DCs and File Servers with no issues.

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Look at using dbAttach to create a backup of the SIMS database. Also get it to backup DMS, then you just need to backup the database backups, the backup of DMS and the SIMS directory.

  3. #3
    mrforgetful's Avatar
    Join Date
    May 2006
    Posts
    1,639
    Thank Post
    7
    Thanked 15 Times in 15 Posts
    Rep Power
    23
    I was just wondering if running a simple complete backup with Windows Backup in Server 2008 would get everything I needed.

  4. #4
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    34
    It may well do it, but Capita recommend using dbattach as it runs some other stuff as part of the backup process I think. I forget the details but it's something to do with how they store the SIMS user accounts in the master database. They may not support you for free if your backup fails to restore properly and you've not followed their published guidance so I wouldn't like to chance it.

    For my nightly backup: I delete the old backup, run the command below, 7zip the resulting file and then back that up along with all the other gubbins under s:\sims and the docstorage.

    Code:
    DBAttach /Server=YOURSIMSSERVER\sims2005 /Database=SIMS /USER=SA /PASSWORD=YOURSAPASSWORD /AUTO /BACKUP /PATH="F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\RemoteBackup\SIMS-DB-nightly.bak"
    As a side note, if you use FMS you should now be backing it up at the same times as you back up SIMS. It uses a different dbattach.exe.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 3rd November 2009, 01:05 AM
  2. Backup Exec 12 problem on Windows 2008
    By TheCrust in forum Windows Server 2008
    Replies: 10
    Last Post: 19th August 2009, 12:16 PM
  3. Active Directory Backup and Restore in Windows Server 2008
    By cookie_monster in forum Windows Server 2008
    Replies: 0
    Last Post: 1st August 2009, 01:48 PM
  4. NT Backup on Server 2008
    By FN-GM in forum Windows Server 2008
    Replies: 15
    Last Post: 12th May 2009, 02:49 PM
  5. Installing SIMS.net on Windows Server 2008 64bit
    By mattstevenson2005 in forum MIS Systems
    Replies: 10
    Last Post: 7th March 2009, 08: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
  •