Is there a way to know how much disk space a SQL Server 2008 database backup file (*.bak) should take up? I am running the backup database command via sqlcmd to backup a DB. However, it seems the *.bak file is getting very bloated. The backup gets run every day. Could the backup be appending the DB backup data to *.bak file that was originally in the \Microsoft SQL Server\...\backup folder? It should be overwriting it each time, but I don't think the file should be growing the way it is. Any thoughts? Thanks.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.