Compressed Backups

• Hany Helmy

  SSChampion

  Points: 13921

  More actions

  June 14, 2014 at 6:20 am

  #1721739

  Stewart "Arturius" Campbell (6/13/2014)

  ---

  Almost missed the critical phrase "in a backup set"

  Good question, Steve, thanks

  + 1 🙂

  Thanks & Best Regards,
  Hany Helmy
  SQL Server Database Consultant

• manik_anu

  SSCrazy

  Points: 2377

  More actions

  June 16, 2014 at 6:35 am

  #1721920

  nice question... i am aware of this kind of restore and backup...:-D

  Manik
  You cannot get to the top by sitting on your bottom.

• pmadhavapeddi22

  SSCertifiable

  Points: 5306

  More actions

  June 17, 2014 at 4:57 am

  #1722242

  Hi,

  I have tried taking the backup with the following t-sql commands

  case I

  -----------------------------------------------------

  backup database XTEST_DB to disk

  ='c:\XTEST_DB.bak' with compression

  backup database XTEST_DB to disk

  ='c:\XTEST_DB.bak'

  -----------------------------------------------------

  Both the backups are successful. first backup is with compression and next one is normal backup, both existed in the same media set.

  but when I use like the below ,

  case II (like the QOTD order)

  -----------------------------------------------------

  backup database XTEST_DB to disk

  ='c:\XTEST_DB.bak'

  backup database XTEST_DB to disk

  ='c:\XTEST_DB.bak' with compression

  -----------------------------------------------------

  Then I am getting the error that both cannot co-exist

  My question is , if both cannot co-exist, first case also should fail , why the first case is successful and where as the second one is not ?

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  June 17, 2014 at 6:03 am

  #1722279

  pmadhavapeddi22 (6/17/2014)

  ---

  Hi,

  I have tried taking the backup with the following t-sql commands

  case I

  -----------------------------------------------------

  backup database XTEST_DB to disk

  ='c:\XTEST_DB.bak' with compression

  backup database XTEST_DB to disk

  ='c:\XTEST_DB.bak'

  -----------------------------------------------------

  Both the backups are successful. first backup is with compression and next one is normal backup, both existed in the same media set.

  but when I use like the below ,

  case II (like the QOTD order)

  -----------------------------------------------------

  backup database XTEST_DB to disk

  ='c:\XTEST_DB.bak'

  backup database XTEST_DB to disk

  ='c:\XTEST_DB.bak' with compression

  -----------------------------------------------------

  Then I am getting the error that both cannot co-exist

  My question is , if both cannot co-exist, second case also should fail , why the first case is successful and where as the second one is not ?

  Nice catch pmadhavapeddi22,

  Looks like it's SQL generosity. :hehe::hehe::hehe:

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  September 5, 2014 at 9:03 pm

  #1743652

  easy & straight forward.

  Thanks.