Will the primary file be restore when restoring a secondary filegroup? Will restoring the secondary filegroup backup replace .mdf and .ldf files?
Does the filegroup backup contain those files? If the backup holds the primary group and they included that in the script, itll restore them..
The script to restore a filegroup backup with only secondary files should look like the below example. (this is the script generated by LS)
exec master.dbo.xp_restore_database
@database = NPRODUCTION DATABASE ,
@tsmconfigfile = NC:\dsm.opt,
@tsmclientnode = N10.1.26.177,
@tsmclientownerpwd = ***,
@tsmobject = Ntest\test\testone,
@tsmpointintime = 2009-12-04 11:24:29,
@filenumber = 1,
@with = NSTATS = 10,
@affinity = 0,
@logging = 0
