<div>
<div class="content wysiwyg-content">
i just did a copy-only backup of a database that is 18 gigs in size with a log file of about 700 meg in size<br />
the bak file is 29 gigs.....<br />
<br />
<br />
backup type was full<br />
<br />
options where back up to the existing media set<br />
append to the existing media set.<br />
<br />
<br />
does anyone know why it is so big... the scheduled full backups are only about 18 gig<br />
my copy is about 75 percent bigger than the actual database itself
</div>
</div>


i just did a copy-only backup of a database that is 18 gigs in size with a log file of about 700 meg in size
the bak file is 29 gigs.....


backup type was full

options where back up to the existing media set
append to the existing media set.


does anyone know why it is so big... the scheduled full backups are only about 18 gig
my copy is about 75 percent bigger than the actual database itself

sql server 2012 backup question

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.

Storage Software

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.