Mac1986 (11/4/2012)
Then can I drop and recreate the DB with My choice of data files?
Are you referring to the source database??
Mac1986 (11/4/2012)
But wait a min the how can I restore the data if its not possible..What options do I have if I want reduce the data files....
Use this to empty and remove unwanted files on either the source or target databases
dbcc shrinkfile(logical_name, EMPTYFILE)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉