digdave7 (6/24/2010)
I was usingALTER DATABASE [XXXX] MODIFY FILE ( NAME = N'VSD2', SIZE = NumberBiggerThatbeforeKB )
Technically they are in filegroups, right now we can't even open the database properties because we get the conversaion failure error.
The error message itself says "Msg 1842, Level 16, State 1, Line 1
The file size, max size cannot be greater than 2147483647 in units of a page size. The file growth cannot be greater than 2147483647 in units of both page size and percentage."
You are trying to grow the file size greater than 2147483647 which is a limitation.
Ref: http://www.sql-server-performance.com/faq/max_size_cannot_be_greater_than_2147483647_p1.aspx
HTH,
Cheers !
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂