InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 12:03:22 GMT20http://www.sqlservercentral.com/Forums/Topic1380756-391-1.aspx[quote][b]Mac1986 (11/4/2012)[/b][hr]Then can I drop and recreate the DB with My choice of data files? 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....[/quote]What difference does it make how many files the database has?What are you trying to accomplish?Mon, 05 Nov 2012 07:37:44 GMTMichael Valentine Joneshttp://www.sqlservercentral.com/Forums/Topic1380756-391-1.aspx[quote][b]Mac1986 (11/4/2012)[/b][hr]Then can I drop and recreate the DB with My choice of data files? [/quote]Are you referring to the source database??[quote][b]Mac1986 (11/4/2012)[/b][hr]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....[/quote]Use this to empty and remove unwanted files on either the source or target databases[code="sql"]dbcc shrinkfile(logical_name, EMPTYFILE)[/code]Sun, 04 Nov 2012 02:56:25 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1380756-391-1.aspxThen can I drop and recreate the DB with My choice of data files? 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....Sun, 04 Nov 2012 02:14:48 GMTMac1986http://www.sqlservercentral.com/Forums/Topic1380756-391-1.aspxNo.A restore will create the same number of files and the same file sizes.Sun, 04 Nov 2012 00:49:41 GMTMichael Valentine Joneshttp://www.sqlservercentral.com/Forums/Topic1380756-391-1.aspxHi Al,I want to restore a database from one server to another server.Can I restore a database with 8 datafiles as 2 data files on a different server? Is it possible?Sat, 03 Nov 2012 19:31:03 GMTMac1986