August 28, 2009 at 6:59 am
When the backup is taken, the .bak file size is same as the log file size.
August 28, 2009 at 7:04 am
Is there a question here? Are you concerned about the backup file size and, if so, why?
Full database backup or log backup?
How big's the data file? How much of the data file is used? How big's the backup?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 30, 2009 at 10:45 pm
Hi Gail Shaw,
The data file is around 560 MB, where as Log is 61 GB. When the backup is taken the size of the .bak file is 61+ GB.
When I checked backing up the other database on the same server (data - 125 MB and Log 2.2 GB), the .bak is around 125 MB
Why does this happen ?
August 31, 2009 at 1:59 am
That's odd. Must be something in the log that the backup needs, maybe an open transaction
Also, I have to ask, a 61 GB log file with a 560 MB data file? Suggests that there's some log maintenance that's not been done.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 31, 2009 at 2:47 am
Any script or routine to follow, please let me know.
I am not aware of any
August 31, 2009 at 3:33 am
Script or routine for what?
What maintenance are you doing on the log? Why is it so large (hint, see sys.databases for the log_reuse_wait_descr column for the reason). What recovery model?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply