SQL Server Backup Data Only

Delete your old backup files.

egomezamsa wrote:

Hello group, I have a 50gb database, when the server made a backup, it weights around 20 gb, this is a big storage problem because my SAN is almost full, Is there a way to backup the database without the objects? or in what table the objects are stored?

Thanks in advance. Best Regards

Before making a backup of your database, try to reduce the log files. The log files may take up a lot of space.
In SQL Server, there is a setting where the maximum size of the database can be stored.

Please proceed with caution, since the log files maybe used as part of the recovery process, so consult with your database administrator first.

bbrown wrote:

The size of the log file has no impact on the size of a full backup. Just the active portion of the log does. However, what can impact the size are transactions completed while the backup is running.

http://www.sql-server-performance.com/forum/threads/database-backup-file-size.22062/

Basically a SQL Backup copies the occupied data/index pages 1:1 to the BAK file, thus - as bbrown already explained - the physical file size is irrelevant, it's the content which matters.

If you are running SQL 2008 R1 EE or SQL 2008 R2 (EE or STD) then you could use the "Backup Compression" feature to reduce the size of the BAK.