question

bmurali09 avatar image
bmurali09 asked

MODIFY FILE failed. Size is greater than MAXSIZE

Hi, Our user database primary data file is having unlimited size with 5% growth. Added 2 ndf files on the database with 2000MB size(Limited) with 5% growth. But My request is i want to change the primary datafile size need to change from unlimited to 5000MB. While changing error throwing(Error 5040). Please help me to solve this issue. Regards Murali
sql-server-2012
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
What's the current size of the primary file? My initial guess is that the primary file is larger than than the max size you are attempting to apply. If this is the case, you'll need to either set a maximum that is higher than the current size of the database or reduce the size of the file in some fashion to get it below that 5GB mark. Once that's done, then you'll be able to set that limit. Hope that helps!
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

bmurali09 avatar image bmurali09 commented ·
Primary file is unlimited size and i want to modify this file in to 5GB. Is is possible to change and give me some steps to modify the file. Regards Murali
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
Not what is the maxsize of the primary file - what is the actual size of the primary file? It sounds like it is already larger than the maxsize you are trying to enforce.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.