MIS Systems Thread, [Discover] Database backup issue [Solved] in Technical; When a discover database is backed up manually using the dbAttach.exe GUI, the backup completes successfully.
Nightly though, we script ...
25th May 2011, 01:39 PM #1
[Discover] Database backup issue [Solved]
When a discover database is backed up manually using the dbAttach.exe GUI, the backup completes successfully.
Nightly though, we script a backup to take place using the dbAttach command parameters to back up SIMS and FMS through a batch file. This always works perfectly and I have modified the script to also backup the new Discover database. The command is exactly the same for the SIMS and FMS backup minus the database name:
When running this through the command prompt, this pops up:
"D:\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\Binn\ dbattach.exe" /BACKUP /AUTO /SERVER=%COMPUTERNAME%\SIMS2008 /DATABASE=Discover /USER=****** /PASSWORD=******
Has anyone else come across this? Is anyone else successfully backing up Discover this way?
Edit: tested on my local XP machine and I get the same issue. Defiantly some kind of problem with dbAttach.
Last edited by Rawns; 25th May 2011 at 02:05 PM.
25th May 2011, 02:57 PM #2
I remember getting that error when trying to use the commandreporter, i think it's just unhappy.
Are you sure all the parameters are correct? servername, instancename etc. I thought Discover was on it's own instance.
Incidentally, i think, you're supposed to use the different dbattach for sims and fms, even though they are exactly the same, it's best practise.
25th May 2011, 03:10 PM #3
All the parameters are 100% correct. Discover attaches itself to the SIMS2008 SQL instance. It says you can put it there in Capita's install guide. I tested it against my own test system and experienced the same issue.
Originally Posted by vikpaw
Also, I told a slight porky in my first post where I said the script was exactly the same for SIMS and FMS. We use the Binn\dbAttach.exe for SIMS and Discover backups and Binn\FMSSQL\dbAttach.exe for the FMS backup.
Last edited by Rawns; 25th May 2011 at 03:13 PM.
25th May 2011, 03:17 PM #4
Does it have it's own dbattach? I've not had a chance to play with it yet. Does it have to be done via dbattach, you could script one in SQL Management studio easy enough until you get the main problem fixed. I just do all mine that way, and it emails me when it's done.
EDIT: Hah! caught you porky pie :P didn't think you'd make a schoolboy error like that..
Last edited by vikpaw; 25th May 2011 at 03:24 PM.
25th May 2011, 03:23 PM #5
No, I don't believe it does have it's own. It's easier to do it through DB attach (if you run dbAttach manually and use the user interface, the backup works perfectly - it's just when scripted)
We will most likely look at a SQL management studio script. The problem is that only our secondary schools have management studio installed and our backup script is used in every school in the county and rolled out daily from one central location. Having it work correctly in our backup routine would be a very quick, pain free method as more schools implement Discover.
25th May 2011, 04:04 PM #6
For an interim measure an osql script would also do the job, or do you need management studio for that too.
26th May 2011, 05:00 AM #7
Out of interest, do we really need to backup the Discover DB? After all, it's contents can be recreated from scratch just by syncing to a fresh DB....
26th May 2011, 09:39 AM #8
True but doesn't it contain the DUDGs plus history and saved analyses. Haven't used so don't know.
26th May 2011, 09:41 AM #9
Yes, any custom Discover aspects/groups etc would be lost so we will be treating this as any other database and backing it up daily. Also, I'm not sure what would happen if you had to roll back SIMS to an old backup and the Discover database had data in it that SIMS database did not.
26th May 2011, 02:32 PM #10
Fair enough. I just have some vague recollection of something said at a an early demo (some 14 months ago) by a Capita guy who said nothing would be stored in the Discover DB except a cache of the data, all the settings etc would be stored in SIMS.
Last edited by NorthernSands; 26th May 2011 at 02:33 PM.
Reason: Speak English, boy!
26th May 2011, 06:39 PM #11
@Rawns have you tried adding the /path?
27th May 2011, 09:16 AM #12
Originally Posted by matt40k
Just tried this and it seems to work. The only down side is that you have to specify a file name with the Path command so there will only ever be one backup as it will overwrite the previous one.
27th May 2011, 09:21 AM #13
27th May 2011, 09:22 AM #14
Last edited by Rawns; 27th May 2011 at 09:25 AM.
By garethedmondson in forum O/S Deployment
Last Post: 20th May 2011, 02:34 PM
By Rawns in forum MIS Systems
Last Post: 6th January 2011, 10:17 AM
By googlemad in forum MIS Systems
Last Post: 24th March 2010, 05:38 AM
By Quackers in forum Scripts
Last Post: 3rd February 2009, 10:42 PM
By ctbjs in forum MIS Systems
Last Post: 17th December 2007, 02:58 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)