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.Devices.AddDevice("C:\backup.bak", DeviceType.File);

I have backup successfully but I failed to restore it in SSMS.

Exception Image

I have restore it with replace existing database. Please help !

migrated from stackoverflow.com Jun 26 '18 at 16:22

This question came from our site for professional and enthusiast programmers.

  • What does your restore statement look like? Based on the picture of text that you have (actual text is better, btw), it looks like didn't specify the WITH REPLACE clause in your RESTORE statement. – Ben Thul Jun 26 '18 at 14:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy