DB compression with SQL Server 2008 R2 -


In SQL Server 2008 R2, the time of backup is available under the 3 mode compression field

  1. Use Default Server Settings
  2. Compress Backup
  3. Do not Compress Backup

    I have a question here that when we backup By choosing the option Collapse Backup , this will affect any data loss or performance problem with DB or it will be or Use default server settings

    < P> Since most systems are I / O-bound and CPU is not I-Bound, backups are almost always complete (and always takes less disk space, as long as the data is already complete with compression on compressed or non-communicable) It would also be more portable because a smaller file is more network-friendly.

    I have never heard of any examples of data loss or performance loss while using compression. The only exception would be a system in which there is no I / O obstacle, but it is already highly CPU-bound (some I / O costs stop for compression from CPU chakras).

Comments

Post a Comment