April 11, 2013 at 12:01 pm
Every one is using compression backup in SQL server 2008 enterpise?
My question is if one of the backup for example full backup is using compression backup, the transaction log or diff is using non- compressed, can the restore be completed using them?
Currently we have enough space on disks, I wonder if I should use compression or not?
The problem by using compression is sometimes people will be not aware of it's done that way, and misunderstand its real size.
One DBA is OK, but if some other users do backup using non-compression, they will be wonder why it it is different.
Thanks
April 11, 2013 at 12:48 pm
sqlfriends (4/11/2013)
My question is if one of the backup for example full backup is using compression backup, the transaction log or diff is using non- compressed, can the restore be completed using them?
Yes. Compression doesn't change the behaviour of a restore or anything around restore paths, it's just a compression of the data in the backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 11, 2013 at 12:57 pm
so that means I can use both compression and non-compression backup files in one restore process together for a database, correct?
Thanks,
April 11, 2013 at 1:06 pm
As long as each backup file is independent (highly recommended whether you compression or not) as you can't mix compressed and uncompressed backups in the same file.
April 11, 2013 at 1:08 pm
Lynn Pettis (4/11/2013)
As long as each backup file is independent (highly recommended whether you compression or not) as you can't mix compressed and uncompressed backups in the same file.
Thanks, good to know, we do have independent file for each backup.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply