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
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!