Increasing the Microsoft SQL Server database file size

If you use the SQL Server database, periodically check the database size to make sure that the database does not reach its maximum size. If you can, increase the maximum size that the SQL Server database holds.
  1. To increase the Microsoft SQL Server database size
  2. On the Microsoft SQL server computer, open the SQL Server Management Studio.
  3. In the Object Explorer, Expand the "Databases" folder, right-click
    sem5
    , and click
    Properties
    .
  4. In the
    Database Properties
    dialog box, select
    Files
    .
  5. Under
    Database files
    , select
    sem5_log1
    , and scroll to the right to view the
    Autogrowth
    column.
  6. In the
    Autogrowth
    column, click the
    ...
    button.
  7. In the
    Change Autogrowth for
    sem5_log1
    dialog box, click
    Unrestricted File Growth
    , and then click
    OK
    .
  8. Click
    OK
    .