August 9, 2012 at 10:49 pm
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.
August 9, 2012 at 10:53 pm
What is the size of database files (.MDF, .NDF) and transaction log files (.LDF)?
Do you take transaction log backups regularly?
August 10, 2012 at 12:40 am
.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.
August 10, 2012 at 2:44 am
Are you taking backing to new file or adding to exisint backup file?
August 10, 2012 at 4:46 am
Actually I don't know. How to know this and change the configuration.
August 10, 2012 at 5:17 am
How are you performing the backups?
Maintenance plan? Script in a job? Manual running of a script?
August 10, 2012 at 8:36 pm
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.
August 21, 2012 at 3:40 am
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
August 28, 2012 at 1:05 pm
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'
September 3, 2012 at 6:13 am
I think you configured backup with append option. So just configured new backup with default options.
-Arun
September 3, 2012 at 10:05 am
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.
September 3, 2012 at 9:20 pm
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
September 3, 2012 at 9:23 pm
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.
September 4, 2012 at 3:10 am
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
September 4, 2012 at 9:51 pm
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