What are the restrictions apply to compressed backups ?

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

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 

Comments or Responses

Login to post response