SQL Server Backup Data Only

egomezamsa

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

Alex_Chow

Delete your old backup files.

DenSter

the objects take up maybe 200MB, that's not going to make any difference.

infonote

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

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.

infonote

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/

bbrown

infonote wrote:

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/

My original post may not have been clear:

The physical size of the log file has no impact on the full backup size.

stryk

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.