| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2007-10-02 : 13:54:54
|
| So what gives.I have a a dump that's about 150 mb, and it restored to about 7 gbMost of it is free space in the data and log fileIs this because it grew in production and no one managed the logs until some point in the future, then left the size the sameSo I'm guessing it's smar enough to make the dump as big as it needs to be, but retains the properties of the data/ log files?Is this correct?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-02 : 13:58:48
|
| It is that size because that's the size of the files at the source.Why would you restraint the data/log file properties? Why not just size the files properly and keep the default properties?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-02 : 14:16:41
|
| this one surprised me once too... had a backup that was 4 gb in size.restore then took 56 gb...._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-02 : 16:40:09
|
"I never ran into that problem since we maintain the health of my databases"Yup, I've got several of those T-shirts  "it's like people don't do maint."Are you gonna tell me something I don't know already?  "So much for restoring to a point in timeLike a point in time 2 years ago"Nah, I don't think its that so much as "This is the MDF/LDF size my database grew to once. Then I discovered Maint and Stuff. Anyways, my database is 5x9s - 99.999% free space  and I'm happy with that, man!"Slight downside is the time to initialise a 99.999% free-space database before actually starting the restore Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-02 : 16:58:52
|
quote:
Originally posted by Kristen
Slight downside is the time to initialise a 99.999% free-space database before actually starting the restore
Luckily that problem no longer exists in 2005.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-10-02 : 17:55:59
|
quote:
Originally posted by tkizer
quote:
Originally posted by Kristen
Slight downside is the time to initialise a 99.999% free-space database before actually starting the restore
Luckily that problem no longer exists in 2005.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
Ahhh, but sadly that's relegated only to Enterprise Edition (Instant File Initialization).... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-02 : 18:03:04
|
| Luckily we only use Enterprise Edition. Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-10-02 : 18:04:21
|
quote:
Originally posted by tkizer
Luckily we only use Enterprise Edition. Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
Same here, you wouldn't believe how difficult it was to find a Std. edition on site a while ago...  |
|
|
|
|
Small Backup file produces huge DB