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
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center