Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

As databases grow in size, the underlying data files will naturally grow as well. When a database grows to the point that a data file filegroup cannot grow any further, further attempts to add data will result in an error. When your data files are full, you can increase free space by manually increasing the size of the files, increasing the free space available on the disk, or by adding additional data files on new disks. Instructions on how to add new files are available Newtablinkaliashereurlhttp://technet.microsoft.com/en-us/library/ms189253.aspx.

Data files may be configured to grow automatically to prevent out-of-space situations, but they remain limited by the space available on the disk drive, and autogrowth should generally be considered a failsafe alternative. It is a better practice to manually grow your data files to accommodate for expected growth before they fill up.

...