While trying to restore SQL Server database or do any other actions which require exclusive database access you may face with the following error:Exclusive access could not be obtained because the database is in use.

In this article we`re going to address the question about autogrowth settings of the database. To be more precise we`re going to talk about database files settings and their autogrowth settings. From the first glance this seems to be an easy question. But in reality it may cause serious issues in mission critical data systems and even downtime. The goal of the article is to decide whether to set the growth in percents or megabytes and what should be the size of the file growth.