patternsqlMinor
SQL Server Backup File Size
Viewed 0 times
filesqlsizeserverbackup
Problem
I am regularly backing up the database using the SQL Server UI (Tasks --> Backup) with Backup Type:Full. Each time I backup, the
What is the reason behind this?
.bak file gets bloated. If I delete the .bak file and do the backup, then 50 MB .bak file is created instead of the 500 MB file that I deleted. What is the reason behind this?
Solution
You are appending the backup into same file so it is actually accumulating the backups. You need to give a new name each time you trigger backup from Tasks->Backup.
Use maintenance plan as it has timestamp for each backup file or else go with Ola Hellengren's solution.
https://ola.hallengren.com/
Use maintenance plan as it has timestamp for each backup file or else go with Ola Hellengren's solution.
https://ola.hallengren.com/
Context
StackExchange Database Administrators Q#181891, answer score: 8
Revisions (0)
No revisions yet.