O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Expanding Databases

As previously discussed, databases can be expanded automatically, or you can intervene and expand them manually. The manual expansion can be accomplished by adding more files to the database or by increasing the size of the existing files. The database expansions can be accomplished with either SSMS or T-SQL.

To expand the size of the data files using SSMS, you right-click the database in the Object Explorer and select Properties. When the Database Properties dialog appears, you select the Files page to list all the files associated with the database. The Initial Size (MB) column displays the current disk allocation for each file. You can enter the new size directly into the column or use the up arrow to increase the size. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required