Are you including your Transaction Log file in the original 36GB?
It could be that the other 19Gig is T-Log.
Jeremy Greaves
Fenris SoftwareConsulting, Inc
> To: [Email address protected]
> From: mssqldba-ezmlmshield-x48244120.[Email address protected]
> Date: Fri, 29 Feb 2008 19:07:41 +0000
> Subject: DB takes 55GB+ for backup? The DB size is only 36GB.
>
>
> Question:
>
>
>
> Has anyone else see this and do you know why?
>
> DB takes 55GB+ for backup? The DB size is only 36GB.
>
>
>
>
>
> Thanks 'n Regards,
>
> Richard
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
MS Sql Server LazyDBA home page