+ Post New Thread
Results 1 to 14 of 14
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 ...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0

    [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:

    Code:
    "D:\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\Binn\ dbattach.exe" /BACKUP /AUTO /SERVER=%COMPUTERNAME%\SIMS2008 /DATABASE=Discover /USER=****** /PASSWORD=******
    When running this through the command prompt, this pops up:

    dberror.bmp

    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.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,969
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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.

  3. Thanks to vikpaw from:

    Rawns (25th May 2011)

  4. #3
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    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.
    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.

    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.

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,969
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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. Reason: edit

  6. #5
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    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.

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,969
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    For an interim measure an osql script would also do the job, or do you need management studio for that too.

  8. #7
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    11
    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....

  9. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,969
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    True but doesn't it contain the DUDGs plus history and saved analyses. Haven't used so don't know.

  10. Thanks to vikpaw from:

    Rawns (26th May 2011)

  11. #9
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    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.

  12. #10
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    11
    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!

  13. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    @Rawns have you tried adding the /path?

  14. Thanks to matt40k from:

    Rawns (27th May 2011)

  15. #12
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by matt40k View Post
    @Rawns have you tried adding the /path?
    Thanks Matt.

    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.

  16. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    /path:"S:\MSSQL10.SIMS2008\MSSQL\Backup\discover_%d ate:~-4,4%%date:~-7,2%%date:~0,2%.bak"

  17. Thanks to matt40k from:

    Rawns (27th May 2011)

  18. #14
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by matt40k View Post
    /path:"S:\MSSQL10.SIMS2008\MSSQL\Backup\discover_%d ate:~-4,4%%date:~-7,2%%date:~0,2%.bak"
    You are on FIRE today mate! Thanks!

    I'd throw Rep your way but it won't allow me to.
    Last edited by Rawns; 27th May 2011 at 09:25 AM.

SHARE:
+ Post New Thread

Similar Threads

  1. [MDT] Database issue - Permissions
    By garethedmondson in forum O/S Deployment
    Replies: 1
    Last Post: 20th May 2011, 02:34 PM
  2. [SIMS] SQL Backup with dbAttach [Solved]
    By Rawns in forum MIS Systems
    Replies: 5
    Last Post: 6th January 2011, 10:17 AM
  3. Restore Capita UnitE database backup
    By googlemad in forum MIS Systems
    Replies: 1
    Last Post: 24th March 2010, 05:38 AM
  4. Scripting the backup of MySQL Database?
    By Quackers in forum Scripts
    Replies: 3
    Last Post: 3rd February 2009, 10:42 PM
  5. Backup failed unlocking database
    By ctbjs in forum MIS Systems
    Replies: 4
    Last Post: 17th December 2007, 02:58 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
  •