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 |
|
raphaelrivest
Starting Member
14 Posts |
 Posted - 2008-11-14 : 14:51:05
|
| Hi,We have a database on SQL Server 2005. We load data every morning. During the day, we make some requests on the database. We don't INSERT/DELETE anything during the day.Which Recovery model should we use?We don't need to back up the transactions made during the day. We just need the snapshot after the morning load.Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-14 : 15:30:50
|
| Simple Recovery model. |
 |
|
|
raphaelrivest
Starting Member
14 Posts |
Posted - 2008-11-21 : 15:24:54
|
Thank you, sodeep!The mdf files are 132 gigs. If we choose the simple recovery model, how much gigs should we expect for the logs. Right now it's over 100 gigs of the ldf files with the full recovery mode. So the DB weights 232 gigs. What will be the gain (how much gigs) if we go with the simple recovery mode?Thanks,Raph.quote:
Originally posted by sodeep
Simple Recovery model.
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-21 : 18:58:39
|
| You log won't grow like this huge if you change your database to simple recovery model. You will save disk space by doing this. Remember to shrink log file to required size with DBCC shrinkfile after you change recovery model. |
|
|
|
|
|
|
Recovery model