+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, SIMS Backups with SQL 2005 in Technical; Hi people, I've got a bit of a space issue when it comes to backing up SIMS. SQL 2005 does ...
  1. #1
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    628
    Thank Post
    41
    Thanked 47 Times in 41 Posts
    Rep Power
    27

    SIMS Backups with SQL 2005

    Hi people,

    I've got a bit of a space issue when it comes to backing up SIMS.
    SQL 2005 does its usual backup of the SIMS database and so, obviously, the backup files mount up over time and take up space.
    I'm fairly certain (correct me if I'm wrong) that there is some facility within SQL 2005 to do a "clean up" once in a while of old backups earlier than a certain date.

    If anyone knows about this and can shed any light, it would be useful.

    Thanks.

  2. #2

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    831
    Thank Post
    177
    Thanked 105 Times in 73 Posts
    Rep Power
    185
    Open SIMS .net, go in to System Manager, click on the Tools menu and choose 'Tidy Backups'. Whichever backup you have selected when you click 'Tidy' will be removed and also any which are older.

    Stuart

  3. #3
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    628
    Thank Post
    41
    Thanked 47 Times in 41 Posts
    Rep Power
    27
    Thanks.

    I'm aware of this within SIMS .NET.
    Apologies for not being specific but I thought there was an automatic facility within SQL 2005.

  4. #4

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    831
    Thank Post
    177
    Thanked 105 Times in 73 Posts
    Rep Power
    185
    Ah - no idea, sorry. Would be interested though!

  5. #5
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    34
    Quote Originally Posted by paulsharpe View Post
    Thanks.

    I'm aware of this within SIMS .NET.
    Apologies for not being specific but I thought there was an automatic facility within SQL 2005.
    When you create your maintenance plan in SQL2005, it should have 2 parts showing in the diagram window looking something like the attachment. If it doesn't, you can add one from the "Maintenance Plan Tasks" palette which should be on the left hand side of the SQL Management Studio window.

    Be aware that SIMS.net does its own db backups prior to every upgrade and these may well be clobbered after your cleanup cutoff (2 weeks in my example) so you might want to move them to a safe place.
    Attached Images Attached Images

  6. Thanks to sahmeepee from:

    WithoutMotive (23rd January 2008)

  7. #6
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    628
    Thank Post
    41
    Thanked 47 Times in 41 Posts
    Rep Power
    27
    @sahmeepee Many thanks for your help.

    After looking at what you suggested, I noticed the Maintenance Cleanup Tasks had been set up but there was no file extension specified. I've specified the .bak extension, ran a test and it worked perfectly.

    Thanks again.

SHARE:
+ Post New Thread

Similar Threads

  1. Error Doing Tidy Backups in Sims.Net
    By tech_guy in forum MIS Systems
    Replies: 0
    Last Post: 7th January 2008, 01:58 PM
  2. Upgrading SIMS to SQL 2005
    By AnnDroyd in forum MIS Systems
    Replies: 13
    Last Post: 9th October 2007, 03:02 PM
  3. SIMS SQL 2005
    By steve in forum MIS Systems
    Replies: 54
    Last Post: 20th August 2007, 01:35 PM
  4. SIMS + SQL 2005?
    By Norphy in forum MIS Systems
    Replies: 22
    Last Post: 5th April 2007, 10:20 AM
  5. SIMS Backups
    By Grommit in forum MIS Systems
    Replies: 21
    Last Post: 30th October 2006, 04:32 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
  •