RE: DB takes 55GB+ for backup? The DB size is only 36GB.

RE: DB takes 55GB+ for backup? The DB size is only 36GB.

 

  

We've had this happen after we've run an optimization job on the DB. The
tlog backup would be 20+G for a 12G DB. Resolved by truncating tlog
immediately prior to full backup.

-----Original Message-----
From: Richard Hagedorn
[mailto:mssqldba-ezmlmshield-x48244120.[Email address protected]
Sent: Friday, February 29, 2008 2:08 PM
To: LazyDBA Discussion
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