There is no restrictions on the SQL recovery mode but from experience Simple recovery does not allow the transaction logs to fill up and cause issues writing to the db.
Of course if you are using Full recovery mode, you could just backup your db often to flush the logs.
A SQL DBA would normally have a preference and this would not be an issue.
Again, there is no restrictions on this.
-Larry
lmurphy1
57 Posts
0
January 13th, 2011 15:00
Of course if you are using Full recovery mode, you could just backup your db often to flush the logs.
A SQL DBA would normally have a preference and this would not be an issue.
Again, there is no restrictions on this.
-Larry