+ Post New Thread
Page 2 of 4 FirstFirst 1234 LastLast
Results 16 to 30 of 50
MIS Systems Thread, SIMS Tidy Backups - SQL 2008 - Autumn release in Technical; Winzip doesn't like it either....
  1. #16

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    173
    Winzip doesn't like it either.

  2. #17
    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

    So you have a file called ccsfms_20091106_143508.bak and a file called ccsfms_20091106_143508.zip? Mmm... not actually thought of this scenario as it shouldn't happen automatically, I assume someone has uncompressed the file from the zip. I'll have a think how I can deal with this and make new release. Thanks for the feedback.
    Not quite....

    There is a file called ccsfms_20091106_143508.bak and when I run your script, a file called ccsfms_20091106_143508.zip is created, and straight after its creation, the ccsfms_20091106_143508.bak file is deleted without being added to the zip file. I assume you script makes the zip file and is ment to add the bak filew to it, then delete the bak file once completed?

    I'll download your updated version and give it another go.

  3. #18
    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
    Updated version
    • Output date\time (good if your logging)
    • If .bak exists and a same named .zip exists, it'll search inside the zip for the same file, if it has the .bak already, it'll just delete the .bak. Otherwise it'll .zip it. (For example, you extract the .bak file and forget to clean up afterwards)
    • I've added the source code as well
    Thanks for this! Just to let you know, no problems opening it here in WinRAR.

  4. #19

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    173
    Tried WinRAR, same problem. I'll try from home later.

  5. #20

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Lets try it as a 7z.
    Attached Files Attached Files

  6. 2 Thanks to matt40k:

    Heebeejeebee (9th November 2009), Rawns (9th November 2009)

  7. #21

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    173
    Perfect, thanks.

  8. #22
    Guest

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

    Smile

    Quote Originally Posted by Rawns View Post
    Not quite....

    There is a file called ccsfms_20091106_143508.bak and when I run your script, a file called ccsfms_20091106_143508.zip is created, and straight after its creation, the ccsfms_20091106_143508.bak file is deleted without being added to the zip file. I assume you script makes the zip file and is ment to add the bak filew to it, then delete the bak file once completed?

    I'll download your updated version and give it another go.

    Hay Matt40k. Just to let you know this seems to be working perfectly now! The date/time feature is a nice little addition and this will defiantly help towards the headaches caused by low disk space because of uncompressed backups!

    Thanks again.

  9. #23
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,050
    Thank Post
    68
    Thanked 75 Times in 59 Posts
    Rep Power
    34
    Quote Originally Posted by matt40k View Post
    Glad it's gone, backups now take seconds not hours. Compression can be done later when the system is not use.
    I'm running two SIMS servers at the moment since I'm just about to roll out the new one system wide but my backups on the old server take over 25 mins to complete and on the new server they take 17 seconds.

    HBJB

  10. #24
    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
    24
    Quote Originally Posted by matt40k View Post
    Lets try it as a 7z.
    Why are there 2 files to download and


    Can this run in scheduled events ?

  11. #25

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,113
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180
    One is the source, the other is the program?

  12. #26

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Indeed, you can create a schedule task, either the .exe with args or the batch file (or vbscript).

    Interesting thing, Autumn removes compression, both for the SQL 2005 and SQL 2008.

  13. #27
    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
    24
    Quote Originally Posted by Edu-IT View Post
    One is the source, the other is the program?
    I do not undersstand... must both be installed or something like that as most installations come in a single zip

  14. #28

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Quote Originally Posted by Grommit View Post
    I do not undersstand... must both be installed or something like that as most installations come in a single zip
    There is two zip\7zip.

    One is the actual program, this has one .exe file, pretty much ready to go.

    The other is the source code, so if you have C# guru you can have a play and make your own version. Basically 99.9% of people won't ever need this.

  15. Thanks to matt40k from:

    Grommit (18th November 2009)

  16. #29
    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
    24
    Quote Originally Posted by matt40k View Post
    There is two zip\7zip.

    One is the actual program, this has one .exe file, pretty much ready to go.

    The other is the source code, so if you have C# guru you can have a play and make your own version. Basically 99.9% of people won't ever need this.
    tHANKS

  17. #30

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    And for those who don't want to register on EduGeek (you fool!!)

    http://matt40k.xen.prgmr.com/tidybac...idybackups.exe

SHARE:
+ Post New Thread
Page 2 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. [SIMS] SIMS 2010 Autumn Pre-Release Note
    By matt40k in forum MIS Systems
    Replies: 8
    Last Post: 28th September 2010, 09:06 PM
  2. Move to SQL 2008 and backups
    By thesthelensman in forum MIS Systems
    Replies: 2
    Last Post: 13th April 2010, 02:16 PM
  3. SIMS Autumn 09 Release - Experiences?
    By pete in forum MIS Systems
    Replies: 35
    Last Post: 26th December 2009, 02:34 PM
  4. SIMS.net Autumn release - Options 5.7
    By localzuk in forum MIS Systems
    Replies: 0
    Last Post: 1st December 2009, 03:37 PM
  5. Error Doing Tidy Backups in Sims.Net
    By tech_guy in forum MIS Systems
    Replies: 0
    Last Post: 7th January 2008, 01: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
  •