+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 22
MIS Systems Thread, SIMS Backups in Technical; How do you back up SIMS.. Do you get SIMS to do its own backup via the System Manager everynight ...
  1. #1
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25

    SIMS Backups

    How do you back up SIMS..

    Do you get SIMS to do its own backup via the System Manager everynight ? (how do I automate this?)

    Or just use Backup exec or NTbackup to backup the whole MSSQL folder to tape and disk ?

  2. #2
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,987
    Thank Post
    275
    Thanked 52 Times in 46 Posts
    Blog Entries
    2
    Rep Power
    48

    Re: SIMS Backups

    We have some sort of scheduled job(set up by our central team), plus another to stop the database, copy those locked files then re-start.

  3. #3

    Join Date
    Jul 2005
    Location
    Corby
    Posts
    1,056
    Thank Post
    12
    Thanked 20 Times in 18 Posts
    Rep Power
    25

    Re: SIMS Backups

    Quote Originally Posted by mark
    We have some sort of scheduled job(set up by our central team), plus another to stop the database, copy those locked files then re-start.
    That's kind of what we have too.

  4. #4
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42

    Re: SIMS Backups

    We use Backup exec to back up the sims database nightly and use the System Manager backup to do on the fly backups.

  5. #5
    Jake's Avatar
    Join Date
    Jan 2006
    Location
    Sunny South Coast
    Posts
    954
    Thank Post
    11
    Thanked 12 Times in 10 Posts
    Rep Power
    22

    Re: SIMS Backups

    Backup Exec here

  6. #6

    Join Date
    Sep 2006
    Location
    Essex
    Posts
    786
    Thank Post
    1
    Thanked 34 Times in 32 Posts
    Rep Power
    24

    Re: SIMS Backups

    One option I have used in the passed, was to write a script to stop the SQL service, xcopy the SIMS.LDF and SIMS.MDF pair (the SQL database) and xcopy the entire SIMS folder to another server. The advantage of this is that you could have a "warm" backup.

  7. #7
    stitch's Avatar
    Join Date
    Jan 2006
    Location
    Wales
    Posts
    122
    Thank Post
    38
    Thanked 9 Times in 9 Posts
    Rep Power
    20

    Re: SIMS Backups

    We use Backup Exec along with the SQL agent add on.

  8. #8
    ajbritton's Avatar
    Join Date
    Jul 2005
    Location
    Wandsworth
    Posts
    1,632
    Thank Post
    23
    Thanked 75 Times in 45 Posts
    Rep Power
    35

    Re: SIMS Backups

    Custom script which calls DBATTACH to make a SIMS backup then calls NTBACKUP to backup to tape.

  9. #9
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25

    Re: SIMS Backups

    Quote Originally Posted by ajbritton
    Custom script which calls DBATTACH to make a SIMS backup then calls NTBACKUP to backup to tape.
    Thanks Guys... I am using Backup Exec with SQL add on... but I would like to have what ajbritton or djm968 use...

    AJ do you have the script that can co Backup exec as that would alsso be a warm backup someting like djm968's

  10. #10
    vsnider's Avatar
    Join Date
    Aug 2005
    Location
    London
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS Backups

    We do what Mark does. Scheduled job to stop the service, give it plenty of time to do the backup (run a test first and add a couple of hours), run whatever backup (we use windows backup), scheduled job to restart the service. Over the last couple of years I remember it not working twice.

  11. #11
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,047
    Thank Post
    22
    Thanked 178 Times in 124 Posts
    Rep Power
    53

    Re: SIMS Backups

    We also run Backup Exec with SQL agent and the DBATTACH script.

    Code:
    dbattach.exe /user:"username" /password:"password" /backup /SERVER:"SERVERNAME" /DATABASE:"sims" /AUTO
    The dbattach file is located in something like C:\Program Files\Microsoft SQL Server\MSSQL\Binn - depends if you run MSDE or full SQL.

    We run it as a nightly scheduled task, just keep an eye on the build up of the backup files - they soon eat into your diskspace.

  12. #12

    Join Date
    May 2006
    Posts
    159
    Thank Post
    5
    Thanked 10 Times in 5 Posts
    Rep Power
    19

    Re: SIMS Backups

    Is there a reason for starting and stopping the SQL Services?

    I assumed volume shadow copy was designed so you didnt have to do this.

    We currently use dbattach to backup the SIMS db then copy it to another server + upload it offsite.

    Other backups (Exchange + sql) are done using a custom NTbackup script.

  13. #13
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,987
    Thank Post
    275
    Thanked 52 Times in 46 Posts
    Blog Entries
    2
    Rep Power
    48

    Re: SIMS Backups

    You can't copy the database files if they're live klawd

  14. #14
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25

    Re: SIMS Backups

    The problem that i am having is that after the Backup exec has run (with SQL add on) is that the 2 SIMS files are not there ?

    any reason why ?

  15. #15
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    893
    Thank Post
    70
    Thanked 85 Times in 70 Posts
    Rep Power
    33

    Re: SIMS Backups

    Quote Originally Posted by Grommit
    The problem that i am having is that after the Backup exec has run (with SQL add on) is that the 2 SIMS files are not there ?

    any reason why ?
    When using BE SQL agent, I believe the database will be represented as Microsoft SQL Server "SIMS" and not as flat files in your backup/restore selections.

    I use both the SQL agent and the DBAttach command line, just in case.



SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Backups
    By Gatt in forum How do you do....it?
    Replies: 8
    Last Post: 20th June 2008, 03:46 PM
  2. Error Doing Tidy Backups in Sims.Net
    By tech_guy in forum MIS Systems
    Replies: 0
    Last Post: 7th January 2008, 02:58 PM
  3. Backups
    By Geoff in forum *nix
    Replies: 8
    Last Post: 10th December 2007, 05:13 PM
  4. Backups
    By DSapseid in forum Wireless Networks
    Replies: 11
    Last Post: 12th March 2007, 11:54 AM
  5. Backups
    By Gatt in forum How do you do....it?
    Replies: 5
    Last Post: 5th February 2006, 12:44 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
  •