April 1, 2010 at 8:17 am
I am doing a differentical backup for 600GB database and the full bak up size for the same is around 100gb but differential bkp which i do every day has 120gb, what might be the reason..
exec master.dbo.xp_backup_database
@database = ,
@filename = ,
@compressionlevel = 2,
@init = 1,
@threads = 3, @with = 'DIFFERENTIAL'
April 1, 2010 at 9:09 am
What do you mean the Full backup of a Database (which is 600 Gb) to be 100 GB..
It should normally not that low unless you are compressing the backup with any 3rd part tool.
Are you seeing the differential backup size to be 120 GB every day or only one off time. Have you checked what's happening on that database, any large movement specific on that day..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
April 1, 2010 at 9:27 am
the differential backup backs up every page or extent that changes since the last full. forgot which on it is. this means that if you run alter index or change a bit value on a row then it will backup a lot more data than just the changes.
a diff backup being as large as a full is nothing to be worried about
April 1, 2010 at 3:33 pm
Run sp_spaceused under your database and post the results here.
MJ
April 1, 2010 at 5:27 pm
What is your backup schedule?
Weekly full, and then daily diff? Something else?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply