Unanswered: Reached the limit of # of device fragments
Trying to altering one of the databases, I have reached number of allowable fragments that can be altered to any given database...
Msg 5028, Level 16, State 1:
Server 'SERVER123', Line 1:
ALTER DATABASE failed. This command will not make changes to a database that
would cause the number of device fragments to exceed the maximum of 128.
Recreate the database and try again.
I tried to drop/recreate the database but devices are too small in size (1G/2G) to make any difference in allocation. So, I dropped all the devices pertaining to the database, worked with UNIX admin to create larger chunck size devices (8G) and recreated database with larger size, but here comes the trouble - when I reloaded the database from the previous backups, I have inherited the layout of the database how it was originally dumped. Of course, there were several devices that had "data" and "log" together, which is a big NO-NO! So, I tried to cleanup. I sp_dropped from "logsegment" data devices and alter "log" on separate device. Is there a better way of handling this situation when you increase device size? Please let me know if you have any other suggestions.