Restoring To Multiple Files

• Rob_T

  SSC Enthusiast

  Points: 176

  More actions

  September 22, 2003 at 7:27 am

  #106615

  Is it possible to restore a backup of a single mdf file database to a database with a single mdf and two ndf's ?

  If so ... how please

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  September 22, 2003 at 3:08 pm

  #475317

  not that I'm aware of. Unless the backup was from these files. You can always use clustered indexes to move things to multiple files later.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net