SQLServerCentral.com / SQL Server 2008 / SQL Server 2008 Administration / Restroing DB to multiple files / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 14:19:53 GMT20RE: Restroing DB to multiple fileshttp://www.sqlservercentral.com/Forums/Topic1464718-1550-1.aspx[quote][b]marks_262 (6/18/2013)[/b][hr]If it is not possible to restore to multiple files, is it possible to automate moving the data to multiple ndf files after the restore?[/quote]Depends what you want to do specifically (and why)There's no ALTER DATABASE SPREAD DATA ACROSS FILES command.Tue, 18 Jun 2013 10:45:58 GMTGilaMonsterRE: Restroing DB to multiple fileshttp://www.sqlservercentral.com/Forums/Topic1464718-1550-1.aspxonly by scripting up exactly what you want to do.Tue, 18 Jun 2013 10:41:37 GMTgeorge sibbaldRE: Restroing DB to multiple fileshttp://www.sqlservercentral.com/Forums/Topic1464718-1550-1.aspxIf it is not possible to restore to multiple files, is it possible to automate moving the data to multiple ndf files after the restore?Tue, 18 Jun 2013 10:27:18 GMTmarks_262RE: Restroing DB to multiple fileshttp://www.sqlservercentral.com/Forums/Topic1464718-1550-1.aspxNot possible. A restore recreates the DB as it was at the time of backup. If the database that was backed up had one data file then the restored database has one data file.Tue, 18 Jun 2013 09:17:57 GMTGilaMonsterRE: Restroing DB to multiple fileshttp://www.sqlservercentral.com/Forums/Topic1464718-1550-1.aspxnope, logical and physical names are a one to one relationshipTue, 18 Jun 2013 09:17:20 GMTgeorge sibbaldRestroing DB to multiple fileshttp://www.sqlservercentral.com/Forums/Topic1464718-1550-1.aspxIs it possible to restore a database's logical path to multiple physical files?The following produces an expected file or id error message.RESTORE DATABASE TestDB FROM DISK = 'Z:\SQLServerBackups\AdventureWorks2012.bak' WITH MOVE 'AdventureWorks2012_Data' TO 'C:\MySQLServer\testdb.mdf', 'C:\MySQLServer\testdb2.ndf', MOVE 'AdventureWorks2012_Log' TO 'C:\MySQLServer\testdb.ldf';GOTue, 18 Jun 2013 09:05:17 GMTmarks_262