Why use mdf instead of sql

LDF records all the transactions and changes to the database. The ldf is critical for disaster recovery. Setting the Initial size and Auto growth for these files, can have a significant impact on the performance or even the ability to use the database. Which in turn impacts the use pf the PDM vault, relying on this database. The default initial size for both files are 8 MB. The initial size is not as important as Autogrowth. And even for Autogrowth, there are no suggested values.

These settings may need tweaking if you experience poor performance. Download Microsoft Edge More info. Contents Exit focus mode. Important We recommend that you back up the database file before you upgrade it. Warning If you upgrade an. Is this page helpful? Yes No. Any additional feedback? Skip Submit. Submit and view feedback for This product This page. Active 12 years, 5 months ago. Viewed 3k times. Improve this question. Cade Roux Pedro Pedro.

Add a comment. Active Oldest Votes. Improve this answer. Remus Rusanu Remus Rusanu k 39 39 gold badges silver badges bronze badges. Matthew Flaschen Matthew Flaschen k 47 47 gold badges silver badges bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.