I need to exclude one of my table in database during backup. So I move the table to another filegroup "SECONDARY".
bkpDifferential.Action = BackupActionType.Files; bkpDifferential.DatabaseFileGroups.Add("PRIMARY"); bkpDifferential.Devices.AddDevice("C:\backup.bak", DeviceType.File);
I have backup successfully but I failed to restore it in SSMS.
I have restore it with replace existing database. Please help !