This post is more than 5 years old

15 Posts

131711

January 13th, 2011 15:00

MS SQL DB Recover Model for vFoglight Pro?

Hello,
i get a question from one of our partners about the support for the different MS SQL Recovery Models (Simple, Full and Bulk-logged).
Is there any restrictions or is it whether what model is used by the MS SQL DB?

(Table from Microsoft)
Thanks
Daniel

57 Posts

January 13th, 2011 15:00

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
No Events found!

Top