backup file size

  • Can anybody help in this matter

    Original database size 100 MB

    Backup files created, in scheduled time but size was 357 MB.

    While creating task for data backup,

    backup type full, backup will expire options was 0 days, I configured the schedule as recurring (enabled checked),occurs daily, occurs one daily and fixed the time for daily routine.

    How I can reduce the size of .bak files in a manageable size.

  • What is the size of database files (.MDF, .NDF) and transaction log files (.LDF)?

    Do you take transaction log backups regularly?

  • .mdf = 80 Mb

    .ldf =26 Mb approximately.

    It was configured in backup job with the option full database backup.

    Whereas .bak file producing 350MB. Did I configured wrong? If I did then what should be the right option.

    * Another question : If I delete the last backup file .bak and assign new plan with management wizard, any problem with that.

  • Are you taking backing to new file or adding to exisint backup file?

  • Actually I don't know. How to know this and change the configuration.

  • How are you performing the backups?

    Maintenance plan? Script in a job? Manual running of a script?

  • Right clicking in the database selecting task then backup, assigning job by selecting script action to job generated by sql server and schedule. Not maintenance plan or writing any script personally. I am steel learning. But may be database backups are growing because service is adding the new backup with the old backups not replacing older one. I have selected expired on 0 (zero) days.

  • deos your script has constant file name like the name of your 300+ mb file and it has

    "WITH NOFORMAT, NOINIT" option?

    then it is updating the backup on same file.

    Regards
    Durai Nagarajan

  • backup will expire options was 0 days

    This option is equivalent to infinite days (never expire)

    Run following sql to check how many backups your media file has?

    RESTORE HEADERONLY FROM DISK = 'BackupFile.bak'

  • I think you configured backup with append option. So just configured new backup with default options.

    -Arun

  • zahid_7777 (8/10/2012)


    Actually I don't know. How to know this and change the configuration.

    Backup and restore are very serious activites. You need to lear it thorouly, practice and become comfortable in performing backup and restore.

  • I just scheduled for backup as recurring, daily, expires 1 day and started sql server agent along with the jobs under it and getting the scheduled backup, but backup steel growing in the rate of double of previous backup. Hope expires in one day is not working. In which point i am doing wrong. Would you let me know? More you may write the appropriate process for scheduled backup. (Look original size of database is not much 105 mb but .bak file size 597 mb

  • May be you are right I will create new backup policy, by adding recurring, daily, expires in 1 day and append option selected. But where can i found append option or default option. Thank you very much.

  • zahid_7777 (9/3/2012)


    May be you are right I will create new backup policy, by adding recurring, daily, expires in 1 day and append option selected. But where can i found append option or default option. Thank you very much.

    how are you creating backup by code or maintanence plan?

    Regards
    Durai Nagarajan

  • Maintenance plan giving error message. But I am right clicking on the database then selecting task and next backup after that selecting the options like expires 1 day, recurring daily, and setting schedule but I didn't find append or default option. Backup is producing everyday but growing almost double in size.

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply