Home Forums SQL Server 2008 SQL Server 2008 Administration Reduce size of BAK file after deleting database table records? RE: Reduce size of BAK file after deleting database table records?

  • December 5, 2012 at 4:42 am

    #1565676

    craig.dixon (12/5/2012)

    Good Morning Leo,

    Thanks for the reply 🙂 When taking the backups, in the overwrite media section, I have selected to "Back up to the existing media set" and the sub-selection "Append to the existing backup set". Could this be the problem? I was worried that if I chose to "overwrite all existing backup sets" and the latest backup was corrupted then all would be lost :crying:

    If you could give me some advice on what you think an ideal configuration would be I would love to test it on my test environment 🙂 and I really do appreciate the help.

    Thanks again,

    Craig

    If you're constantly appending the backups then that is why the file continously grows. Try implementing an intelligent backup script that creates each file as a new file using details such as servername, database name, backup type and date time stamp. So for instance

    Mysqlserver_Mydb_Full_20121205_113000.trn

    Mysqlserver_Mydb_Tlog_20121205_020000.bak

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉