Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

backup file size Expand / Collapse
Author
Message
Posted Thursday, August 09, 2012 10:49 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 01, 2013 12:41 AM
Points: 44, Visits: 84

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.
Post #1343131
Posted Thursday, August 09, 2012 10:53 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:19 AM
Points: 1,101, Visits: 5,271
What is the size of database files (.MDF, .NDF) and transaction log files (.LDF)?

Do you take transaction log backups regularly?
Post #1343133
Posted Friday, August 10, 2012 12:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 01, 2013 12:41 AM
Points: 44, Visits: 84
.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.
Post #1343163
Posted Friday, August 10, 2012 2:44 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:19 AM
Points: 1,101, Visits: 5,271
Are you taking backing to new file or adding to exisint backup file?
Post #1343203
Posted Friday, August 10, 2012 4:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 01, 2013 12:41 AM
Points: 44, Visits: 84
Actually I don't know. How to know this and change the configuration.
Post #1343273
Posted Friday, August 10, 2012 5:17 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 2:37 AM
Points: 5,075, Visits: 4,834
How are you performing the backups?

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





Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1343296
Posted Friday, August 10, 2012 8:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 01, 2013 12:41 AM
Points: 44, Visits: 84
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.
Post #1343741
Posted Tuesday, August 21, 2012 3:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
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
Post #1347660
Posted Tuesday, August 28, 2012 1:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 17, 2014 7:43 AM
Points: 114, Visits: 985
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'

Post #1351199
Posted Monday, September 03, 2012 6:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 20, 2014 3:50 PM
Points: 28, Visits: 104
I think you configured backup with append option. So just configured new backup with default options.

-Arun
Post #1353484
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse