SQL Server Performance

Restoring filegroup to a brand new database

Discussion in 'ALL SQL SERVER QUESTIONS' started by WingSzeto, Dec 16, 2011.

  1. WingSzeto Member

    Our regular database contain 1 default primary group and my user defined file group. I know I can do the backup of just that user defined file group. I am wondering if I can restore just that user defined file group to a new database (different database name) in the same SQL server. In other words, the new database would only contain that filegroup and I don't want the primary group from the original database. Is it possible?

    W
  2. Luis Martin Moderator

    As far I know, no. Wait for other members.
  3. satya Moderator

Share This Page