Limiting Database Size for SmartPTT

Prerequisites

• Start SQL Server Management Studio (SSMS) on the MSSQL host.

Process

1. In the SSMS, access the Object Explorer panel.

   

2. Connect to the requires MSSQL server.

   How to...

   1. In the panel, from the Connect list, select Database Engine.
      Server connection settings appear.

      

   2. In the window that appears, in the Server name field, enter localhost\<server name>.

   3. From the Authentication list, select Windows Authentication.
   4. Click Connect.

3. In the Object Explorer panel, expand <hostname>\<MSSQL instance name> → Databases.

4. Right click the required database name, and from the action menu, select Properties.
   Properties appear in the dedicated window.

   

5. Set up database growth:

   1. In the right pane, in the entry, where the File Type is equal to ROWS Data, in the Autogrowth / Maxsize column, click Browse .
      Autogrowth settings appear.

      

   2. In the window that appears, select the Enable Autogrowth check box.

   3. In the Maximum File Size area, click Limited to.
   4. In the text box next to the Limited to, enter the maximum database size in megabytes.
   5. Adjust the database growth increment.
   6. In the Change Autogrowth window, click OK to save changes and close the window.
   7. In the Properties window, click OK to save changes and close the window.
   8. On the Object Explorer panel, right click <hostname>\<MSSQL instance name>, and from the action menu, select Restart.