Home Forums SQL Server 2008 SQL Server 2008 Administration Restroing DB to multiple files RE: Restroing DB to multiple files

  • June 18, 2013 at 10:45 am

    #1625146

    marks_262 (6/18/2013)

    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?

    Depends what you want to do specifically (and why)

    There's no ALTER DATABASE SPREAD DATA ACROSS FILES command.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass