Hi

The online backup utility you use, you mentioned that you can not remove certain files.

Do you mean there are files in your backup folder other than those with the .BAK...

I have been through the process of hiring staff and this is what we found:

* Staff with certifications without experience mostly did not pass our entry test

* Candiadates with experience...

Hi

The install file is called: SQL2008_DEV_CTP3_Nov_ENU.exe (20 Nov 2007)

SQL 2008 Developer Edition CTP3 November 2007

Version Number = 10.0.1075

Thanks

Kevin

Hi

That does sound about right. If the SQL Engine has the compression built in then it would be crazy to have diffirent versions or limitations based on the edition.

But yes...

I do not have any info on a better spec'd server - but may in the near future.

I have not investigated the possibility of adjusting the compression percentage, but this...

Hi

The environment was a Virtual PC - running XP SP2 with 1GB RAM.

There was no other applications running on this machine at the time of the backup.

Thanks

Kevin

I will test this for you - when back at the office and give you feedback

Thanks

Kevin

Hi

I have a 109GB, 110GB, 111GB.. Database that I am in the process of testing with and I will be doing a follow-up article - possibly in more technical detail.

I...

Yes, in SQL 2008 - the Database Mirrioring and Log Shipping* also benefit from this compression technology built into the engine.

I am not sure if this is default or a...

I think this is an Enterprise feature only

SQL 2008 does still support this feature of splitting the Backup over multiple files.

During Backup and compression it was writting to each of the 5 files in a series basis...

If you mean adding multiple files as the destination for the Backup - then yes the above is true, and you may even be able to experiment with reducing the...

From the article the DB used was able to be backed up in approx half the time and the size of the backup file was approx 1 third or 30%...

The compression on compression is an interesting question...

If the backup software placing data onto disk is sophisticated enough and it encounters a file with a zip header - does it...

Yes, the restore from compressed .BAK file will be an interesting item to investigate.

I will get my environment up and running and either post feedback on this discussion or provide...