• digdave7 (6/29/2010)


    Hi Gail,

    I ran

    ALTER DATABASE [VSD] MODIFY FILE ( NAME = N'VSD', SIZE = 29864824 MB )

    29 Terabytes? That's what the alter database you have there sets the file size to. Is that really the size that you want the file?

    The maximum size of a database file is 16 terabytes, so I would fully expect that alter database to fail. If you really do have a database that's many terabytes in size, you'll have to add more files to the existing filegroups rather than grow existing files, as the hard limit on the size of a single file is 16 TB (16777216 MB)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass