I had a server running that had a disk crash. The server had 2 filegroups: PRIMARY and SECONDARY. SECONDARY was stored in a different NDF file. I lost SECONDARY + the installation of the server, I have the MDF file of the PRIMARY filegroup. I also have a backup from a few months ago. Is there a way to attach the MDF file I have without the NDF I lost? I don't mind losing the tables stored on the SECONDARY filegroup.
I'm using SQL Server 2008R2 DEV. Thanks!