| Author |
Topic |
|
kjk_kjp
Starting Member
18 Posts |
 Posted - 2012-09-18 : 11:44:50
|
| I'm working on a daily snapshot of some data - the daily snapshots will happen once a day and will consist of about 20MB of data daily.What would you all suggest is the best way to go about dealing with the backups and transaction logs in regards to helping us save disk space?Also - would you suggest any routine "shrink" of the database?Any other suggestions would be welcomed. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kjk_kjp
Starting Member
18 Posts |
Posted - 2012-09-18 : 14:08:06
|
| I'm not concerned about the 20MB daily, but over time, this will add up...Just trying to be proactive rather than re-active...Our current SQL server has roughly 250GB available storage on it currently - I understand I will have at least a year or two before I would have to really worry, but would like to do it right the first time around. |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-18 : 14:36:56
|
| You shouldn't be keeping your backups on that server anyway.-Chad |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-09-18 : 14:43:43
|
quote:
Originally posted by kjk_kjp
I'm not concerned about the 20MB daily, but over time, this will add up...Just trying to be proactive rather than re-active...Our current SQL server has roughly 250GB available storage on it currently - I understand I will have at least a year or two before I would have to really worry, but would like to do it right the first time around.
20MB per day is only 7300MB per year, that's ~7.3GB. 250/7.3 is 34 years.  Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kjk_kjp
Starting Member
18 Posts |
Posted - 2012-09-18 : 14:53:45
|
| Tara - would tlog backups every 15 minutes be needed - I will only being doing the snapshot once a day - meaning data will only be changing one time each day. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-18 : 14:55:28
|
| Honestly, we can't tell you what the best Backup scenario is for you as that is dependant on what your business requirements and SLAs are.-Chad |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-19 : 01:47:01
|
| The question to ask the business is "what is the acceptable data loss if we lose the server" - if they say 60 minutes - then base your backup strategy around those figures.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
SQL server what backup is best