How to dynamically create my FILEGROUP during a restore?

• Express12

  SSCoach

  Points: 18514

  More actions

  July 18, 2013 at 7:22 am

  #276122

  How can I dynamically create my FILEGROUP during a restore?

  My FILELISTONLY renders

  [font="Courier New"]LogicalName PhysicalName Type FileGroupName

  =========== ============ ==== =============

  MyDBData_Primary G:\SQLData\Archive_Primary.mdf D PRIMARY

  MyDBData_1 G:\SQLData\MyDB_1.ndf D DataFileGroup

  MyDBData_2 G:\SQLData\MyDB_2.ndf D DataFileGroup

  MyDBLog L:\SQLLogs\MyDB.ldf L NULL[/font]

  How can I tweak the following RESTORE command to dynamically generate the FileGroupName called 'DataFileGroup' listed above?

  RESTORE DATABASE MyDB FROM DISK='H:\SQLBACKUPS\MyDB.bak'

  WITH RECOVERY, REPLACE,

  MOVE 'MyDBData_Primary' TO 'E:\SQLData\MyDB_Primary.mdf',

  MOVE 'MyDBData_1' TO 'E:\SQLData\MyDB_1.ndf',

  MOVE 'MyDBData_2' TO 'E:\SQLData\MyDB_2.ndf',

  MOVE 'MyDBLog' TO 'F:\SQLLogs\MyDB.ldf'

  GO

  BT

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  July 18, 2013 at 7:25 am

  #1633639

  You don't need to. The restore will create an exact copy of the database, including filegroups.

  John

• Express12

  SSCoach

  Points: 18514

  More actions

  July 19, 2013 at 4:47 am

  #1633928

  John - thanks. Right on w/ your reply. The restore created the FG. Appreciate your feedback.

  BT