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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Server 2008 database size
- Thread starter sqlguy1
- Start date
- Status
Similar threads
- Locked
- Question