I got an issue. I have a database (Say, DBASE) which have three files - Two data files (namely D:\Data1.mdf and D:\Data2.ndf) and a log file (E:\log.ldf) and all are in different file group. The secondary data file i.e., Data2.ndf is in recovery pending state. Remaining two db files are good and my database is online. When I took a look on database properties (GUI), I found there the size of Data2.ndf as 0MB where it's actual size is 10GB. We have given a try in below methods to fix the issue, but no luck.
- Taking database to offline, then back to online.
- Detach and attach operations
- No errors from checkdb, unfortunately we don't anything in error log (as they are recycled)
Can someone help me in fixing the issue please?
FYI - Version : SQL 2012 SP1 Enterprise.