Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2006-08-30 : 12:45:34
|
| We are currently using a full recovery model.We are doing a fullback up everyday and a transaction log back up every hour.Is it ok to do a differential back up twice per day ( along with a transaction log back up every hour) and a fullback up only once a week to save some disk space?what is the best back up strategy that can accommodate both minimizing the loss time and managing the efficient disk space.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-30 : 12:47:28
|
| Yes that is fine.Tara Kizer |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-30 : 12:55:54
|
| Each diff will include all the changes since the last backup so if you are changing lots of data on the database the diff can end up as big as the full.Get more disks - they are relatively cheap compared to peoples time.Are you moving the backups off the server? If not then you should be and then you can delete the files from the server.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2006-08-30 : 15:30:35
|
| Thanks!It's in RAID configuration..D0 you meant I have to move the backup files to the different server ( different physical location)? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-30 : 18:19:11
|
| Yes, that's the recommendation. We backup our files to tape plus copy them to a different server. Thus we can delete them and get them back again if needed.Tara Kizer |
|
|
|
|
|
|
Fullback up with a fullrecovery model