+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, SIMS Backup (Idiotic Question) in Technical; Hi folks, I know that backing up SQL Server (and therefore SIMS) isn't that straightforward. Is it possible to backup ...
  1. #1
    Gongalong's Avatar
    Join Date
    Oct 2011
    Location
    United Kingdom
    Posts
    908
    Thank Post
    820
    Thanked 19 Times in 17 Posts
    Rep Power
    10

    Question SIMS Backup (Idiotic Question)

    Hi folks,

    I know that backing up SQL Server (and therefore SIMS) isn't that straightforward.

    Is it possible to backup the SIMS database from one folder to another while it's in use?

    TIA

  2. #2

    Join Date
    Jan 2007
    Posts
    100
    Thank Post
    0
    Thanked 34 Times in 23 Posts
    Rep Power
    21
    You can use
    OSQL -S <SQL Instance Name> -E -Q "BACKUP DATABASE SIMS TO DISK = '<Required Path>\SQLSIMS_SCH.bak'"
    Put your required info between the <>'s

    I always prefer all users out though

  3. Thanks to Greg from:

    Gongalong (23rd October 2012)

  4. #3
    Gongalong's Avatar
    Join Date
    Oct 2011
    Location
    United Kingdom
    Posts
    908
    Thank Post
    820
    Thanked 19 Times in 17 Posts
    Rep Power
    10
    Thanks. Presumably it could be setup as a scheduled task over the weekend, when it's likely not to be in use.

  5. #4

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,817
    Thank Post
    272
    Thanked 1,138 Times in 1,034 Posts
    Rep Power
    350
    You should be able to setup a SQL agent job to run a backup to a local drive partition - back this up using any other backup software


    How-To: Backup a Database Using SQL Server Management Studio - YouTube

    You then need to take a copy of the Simsroot folder (say once a week as not much changes) and the docstorage share. The doc storage is more important,

  6. Thanks to glennda from:

    Gongalong (23rd October 2012)

  7. #5

    twin--turbo's Avatar
    Join Date
    Jun 2012
    Location
    Carlisle
    Posts
    2,334
    Thank Post
    1
    Thanked 381 Times in 340 Posts
    Rep Power
    150
    it was once part of sims anyway to do it's own SQL backup. have they got rid of that ( it did cause some trouble with disk space )

    Rob

  8. Thanks to twin--turbo from:

    Gongalong (23rd October 2012)

  9. #6

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,817
    Thank Post
    272
    Thanked 1,138 Times in 1,034 Posts
    Rep Power
    350
    Quote Originally Posted by twin--turbo View Post
    it was once part of sims anyway to do it's own SQL backup. have they got rid of that ( it did cause some trouble with disk space )

    Rob
    You can still use DBattach I think (although been out of the loop with sims for a while.) I'll see if I have the dbattach script on my email somewhere

  10. 2 Thanks to glennda:

    Gongalong (23rd October 2012)

  11. #7
    Gongalong's Avatar
    Join Date
    Oct 2011
    Location
    United Kingdom
    Posts
    908
    Thank Post
    820
    Thanked 19 Times in 17 Posts
    Rep Power
    10
    There is the folder MSSQL10.SIMS\MSSQL\Backup. For us this currently has 10 .BAK files, all around 3GB each. 5 of them are dated 13th Sep, 3 are dated 17th Aug, 1 is 30th Jul, and the last is 18th May

    Edit: there's also D:\SIMS\SIMS\SQL DATA BACKUP which has an EXE file in (dated 22 Oct) around 500MB. There are other folders though with lots of data e.g. D:\SIMS\SIMS\DOCSTORAGE, which has around 6GB. Our SIMS.LDF file in D:\Microsoft SQL Server\MSSQL10.SIMS\MSSQL\DATA is 58GB (!).
    Last edited by Gongalong; 23rd October 2012 at 03:06 PM.

  12. #8

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,817
    Thank Post
    272
    Thanked 1,138 Times in 1,034 Posts
    Rep Power
    350
    Quote Originally Posted by Gongalong View Post
    There is the folder MSSQL10.SIMS\MSSQL\Backup. For us this currently has 10 .BAK files, all around 3GB each. 5 of them are dated 13th Sep, 3 are dated 17th Aug, 1 is 30th Jul, and the last is 18th May
    That would be the backups Sims is auto-doing when you perform and upgrade or from inside System Manager.

    Attached is a script which uses DBAttach. I've taken this from a friend and accept no responsibility.
    Attached Files Attached Files

  13. 2 Thanks to glennda:

    Gongalong (23rd October 2012)

  14. #9

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,990
    Thank Post
    114
    Thanked 506 Times in 341 Posts
    Blog Entries
    2
    Rep Power
    286
    As @Greg has said, you can script a backup with code like his or use SQL Management Studio to configure a regular job to backup the database.

    There's absolutely no need to get anyone out of the system, though. The SQL server is designed to be backed up while it's in full flow with no problems. The only reason to do it out of hours is that the backup might have a noticeable impact on performance.

  15. Thanks to jinnantonnixx from:

    Gongalong (24th October 2012)

  16. #10
    Gongalong's Avatar
    Join Date
    Oct 2011
    Location
    United Kingdom
    Posts
    908
    Thank Post
    820
    Thanked 19 Times in 17 Posts
    Rep Power
    10
    We already backup SIMS with DPM, but this is a further offsite backup which we'd like to do via CrashPlan. We're likely to just use the file/folder backup of CrashPlan, but of course I'd need to backup SIMS in such a way that we could be sure of restoring the content.

    I thought it best to also check this with our CC IT team, as they installed the server. I'll feed back their advice here.

  17. #11

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,072
    Thank Post
    377
    Thanked 380 Times in 309 Posts
    Blog Entries
    8
    Rep Power
    178
    +1 for SQL backup via SSMS. Although remember due to SIMS' weird way of managing permissions if you restore using this backup usually user account passwords are screwed up. Peeps on here know a script to fix this though.

  18. Thanks to GREED from:

    Gongalong (24th October 2012)

  19. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    I use a backup job i've setup in SQL Management Studio, and this has a linked task to email me either success or failure. The only time it ever fails is because there is not enough room on the share i'm backing up to.

    Your LDF file is massive, and you should ask your CC team about their implementation method and what they suggest. You can shrink this, after doing a transaction log backup. It might be the case that you switch to Simple Mode, which will prevent this growth. You don't really want an LDF that big. How big is the MDF? Around 3GB?
    You can also alter the growth rate to control it more.

    It might be worth looking on Capita's SupportNet for their best practice guides as well.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS: Backup and Recovery
    By Gongalong in forum MIS Systems
    Replies: 6
    Last Post: 30th June 2012, 09:41 AM
  2. [SIMS] Sims Backup
    By squeeky in forum MIS Systems
    Replies: 45
    Last Post: 28th June 2012, 01:33 PM
  3. [SIMS] SIMS Backup - the latest
    By msi in forum MIS Systems
    Replies: 8
    Last Post: 7th January 2012, 10:03 PM
  4. [SIMS] Who's using TidyBackups to managed the SIMS backups?
    By matt40k in forum MIS Systems
    Replies: 10
    Last Post: 22nd March 2011, 11:20 AM
  5. [SIMS] Sims backup regimes
    By creese in forum MIS Systems
    Replies: 6
    Last Post: 13th September 2010, 09:52 AM

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
  •