March 23, 2003 at 11:34 pm
Is there any security issues if i keep the database recovery model of the databases to simple in production server?
March 24, 2003 at 12:37 am
No. Data recovery model does not refer to security, but rather how much data you can get back should a failure occur. This may help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4l83.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
March 24, 2003 at 10:30 am
The simple recovery model is well-suited for DBs that are mostly read-only, or where changes are applied in bulk and can be redone programmatically if needed. Obviously not a good choice for an OLTP system.
-Dan
-Dan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply