Why are the *.bak file sizes changing? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Why are the *.bak file sizes changing?

Author

Topic

cddot
Starting Member

37 Posts

Posted - 2009-05-05 : 00:49:29

The *.bak file sizes from a particular database is as follows:

04/22/2009 02:00 AM 336,098,816 abc_db_backup_200904220200.bak
04/23/2009 02:01 AM 336,098,816 abc_db_backup_200904230200.bak
04/24/2009 02:01 AM 336,098,816 abc_db_backup_200904240200.bak
04/26/2009 02:01 AM 167,001,600 abc_db_backup_200904260200.bak
04/26/2009 02:01 AM 167,001,600 abc_db_backup_200904260201.bak
04/27/2009 02:01 AM 334,001,664 abc_db_backup_200904270200.bak
04/28/2009 02:01 AM 334,001,664 abc_db_backup_200904280200.bak
04/29/2009 02:01 AM 167,001,600 abc_db_backup_200904290200.bak
04/29/2009 02:01 AM 167,001,600 abc_db_backup_200904290201.bak
04/30/2009 02:00 AM 167,001,600 abc_db_backup_200904300200.bak
04/30/2009 02:01 AM 167,001,600 abc_db_backup_200904300201.bak
05/01/2009 02:00 AM 167,001,600 abc_db_backup_200905010200.bak
05/01/2009 02:02 AM 167,001,600 abc_db_backup_200905010201.bak
05/02/2009 02:00 AM 167,001,600 abc_db_backup_200905020200.bak
05/02/2009 02:01 AM 167,001,600 abc_db_backup_200905020201.bak
05/03/2009 02:00 AM 167,001,600 abc_db_backup_200905030200.bak
05/03/2009 02:01 AM 167,001,600 abc_db_backup_200905030201.bak
05/04/2009 02:00 AM 167,001,600 abc_db_backup_200905040200.bak
05/04/2009 02:01 AM 167,001,600 abc_db_backup_200905040201.bak
05/05/2009 02:01 AM 334,001,664 abc_db_backup_200905050200.bak

Sometimes it produces 1 file, other times it produces 2 files at 1/2 the size. What is causing this inconsistency?

malaytech2008
Yak Posting Veteran

95 Posts

Posted - 2009-05-05 : 02:42:22

are you coding to take the backup manually..can provide more details about backup model.

malay

cddot
Starting Member

37 Posts

Posted - 2009-05-05 : 05:02:09

This is just a standard Back Up Database Task consisting of two subtasks, and I just noticed maybe the reason is due to the "Append existing" and two "Full" backups?

The two subtasks (is that the correct term?) are joined by a dependency arrow:

Back Up Database (Full)
Backup Database on Target server connection
Databases: db1, db2, ... etc
Type: Full
Append existing
Destination: Disk
|
V
Back Up Database (Transaction Log)
Backup Database on Target server connection
Databases: db1, db2, ... etc
Type: Full
Append existing
Destination: Disk

SQL Server 2005/Management Studio version 9.00.2047

Disclaimer: I didn't set this thing up, it was done by someone else before me.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources