7

When restoring a full DB backup to a different SQL Server 2005 Express server, I receive the following message:

The file or filegroup "mydatabase_log" cannot be selected for this operation. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3219)

I've checked the restore options to make sure that filenames are valid locations for it to restore to.

Any suggestions?

Daniel O
  • 2,810
  • 3
  • 28
  • 35

2 Answers2

12

I fixed it by using Restore Database instead of Restore Files

Daniel O
  • 2,810
  • 3
  • 28
  • 35
0

You have checked the 'Force Restore' box in the options?

Cruachan
  • 15,733
  • 5
  • 59
  • 112