What are the restrictions apply to compressed backups ?

Posted by PandianS on 10/31/2010 | Category: Sql Server Interview questions | Views: 4505 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

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 | Alert Moderator