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 ...
30th September 2009, 01:08 PM #1
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.
IDG Tech News
30th September 2009, 03:56 PM #2
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.
30th September 2009, 03:59 PM #3
I was just wondering if running a simple complete backup with Windows Backup in Server 2008 would get everything I needed.
30th September 2009, 06:01 PM #4
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.
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.
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"
By albertwt in forum Thin Client and Virtual Machines
Last Post: 3rd November 2009, 01:05 AM
By TheCrust in forum Windows Server 2008
Last Post: 19th August 2009, 12:16 PM
By cookie_monster in forum Windows Server 2008
Last Post: 1st August 2009, 01:48 PM
By FN-GM in forum Windows Server 2008
Last Post: 12th May 2009, 02:49 PM
By mattstevenson2005 in forum MIS Systems
Last Post: 7th March 2009, 08:08 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)