If you’re using the SQL Server Management Studio GUI, you can increase the size of a data file by right-clicking on the relevant database, selecting Properties, selecting Files under Database Properties, then increasing the value in the Initial Size (MB) column for the applicable data file.
If you’re using Transact-SQL however, you can increase the data file’s size by using the ALTER DATABASE
statement with the MODIFY FILE
argument. The following example demonstrates how to do this.