The compressed backup was introduced in SQL Server 2008 Enterprise.So this technique applicable in SQL Server 2008 Enterprise Edition and Later.
The following are the compressed backup restrictions :
1. Compressed and uncompressed backups cannot co-exist in a media set.
2. Previous versions of SQL Server cannot read compressed backups.
3. NTbackups cannot share a tape with compressed SQL Server backups.
Asked In: Many Interviews |