[SIMS] SIMS Tidy Backups - SQL 2008 - Autumn release

[creese]

Winzip doesn't like it either.

[Rawns]

@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.

[Rawns]

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.

[creese]

Tried WinRAR, same problem. I'll try from home later.

[matt40k]

Lets try it as a 7z.

[creese]

Perfect, thanks.

[Rawns]

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.

[Heebeejeebee]

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

[Grommit]

Lets try it as a 7z.

Why are there 2 files to download and


Can this run in scheduled events ?

[Edu-IT]

One is the source, the other is the program?

[matt40k]

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.

[Grommit]

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

[matt40k]

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.

[Grommit]

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

[matt40k]

And for those who don't want to register on EduGeek (you fool!!)

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