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 |
|
rajesha
Starting Member
36 Posts |
 Posted - 2003-03-24 : 01:20:47
|
| Is there any security issues if i keep the database recovery model of the databases to simple in production server? |
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2003-03-24 : 02:28:51
|
Hi, Could u plz explain further what exactly wd u want ?  RoyalSher |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-03-24 : 02:39:38
|
| It's more a recoverability issue than a security one. When a database is in simple recovery mode it can only be restored upto the last full or differential backup. Any transactions done after this point will need to be redone. With bulk logged you can recover to the end of the latest transaction log backup. With full you can recover to a point in time or transaction mark. So it's up to the business to determine what kind of data loss might be acceptable. If a database is only loaded once a day and then is readonly then a full backup after the load may well be acceptable. For an OLTP database then transaction log backups every 15 minutes may be more appropriate. Please do read up on Recovery models in BOL.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
|
|
|
database recovery model