I have a database (MyDatabase) with 2 filegroups,
[SECONDARY] filegroup has 2 datafiles,
[DataFileA] is damaged (even after
DBCC CHECKDB process).
I tried to solve it with:
DBCC CHECKDB ([MyDatabase], REPAIR_ALLOW_DATA_LOSS)but it didn't help.
- Deleted the damaged datafile
[DataFileA], with no success.
[PRIMARY] filegroup is ok though.
Can I backup just the
[PRIMARY] filegroup and restore it (under a new name) and create a new database from this single filegroup?