How can we help you today? How can we help you today?

disk space question

I've downloaded the trial and everything seems great but I have one remaining issue I can't resolve. I have a 50GB database that can be compressed down to 6GB backup. It looks like a full backup is done and then it is compressed, so if I only have say 10Gb available on my drive, will the backup still work because the final file is only 6GB or will there be an issue because the SQL backup is still about 50GB and it needs to exist somewhere to be compressed.

Will a similar thing work with my 500GB database and not enough disk space to hold the normal SQL backup of that DB?

Thanks,

David
dgrace
0

Comments

2 comments

Sort by
  • James Moore
    Hi David,

    SQL Backup compresses the backup on the fly so the full uncompressed backup never exisits and thus the amount of disk space you need is much less than for native backup.

    It is always wise to give a little leaway so that if your database grows then the backup will not fail but you certainly won't need enough space for the full uncompressed backup.

    James
    James Moore
    0
  • dgrace
    Thank you James. That is what I was expecting, since it wouldn't be as much use if it didn't but just wanted to make sure. Unfortunately for me, I couldn't test it because my dev server had too much room available.

    Guess I'll go speak to the man with the corporate card.

    Thanks again,

    David
    dgrace
    0

Add comment

Please sign in to leave a comment.