Hello All I have be assigned of moving a database from one production to other production box. I need to follow new conventions laid per the Mgmt team, that I need to have data files split up in different drives raided differently. Say .MDF files should be in G drive, .LDF files should be in E drive..etc. In one of these laid conventions I need to have all new databases migrated or newly created to be having multiple files with MAXSIZE of 2 Gigs, FILEGROWTH OF 100 Megs. Now the trick is that I need to have an existing database restored (moved) from old production box to the new, such a way that I have multiple files..per above conventions, of the restored database. But, the database on the old box has present structure of a single .MDF file. Now, when I do the restore operation I will have logical file with single .MDF. I am aware of one of few methods that I need to create a database with new conventions & import data to the destination database from source. I am sure, this would be last option for me as the database has data of 100+ Gigs. Can anybody out there help me with any other method on taking care of this? Thanks in advance! RoyalSher. ********* The world is the great gymnasium where we come to make ourselves strong.