The empty filestream filegroup physical file got deleted while playing with the FileStream feature on a database. Now the database is in Emergency mode. It appears as though there is no recent backup. Yes, I know I’m an idiot for at least two reasons.
dbcc checkdb (dbname, repair_allow_data_loss) gives following error:
Unable to open the physical file “C:helpdb_Help”. Operating system error 2: “2(The system cannot find the file specified.)”. The file is not in the recycle bin.
I don’t need this FileStream filegroup. There is no data in it (certainly none I care about). All alter database commands fail giving the error that the database cannot be opened due to inaccessible files.
Is there any way to tell SQL Server to ignore this filegroup when opening database?
Is there anyway to copy mdf and ldf and restore to a point in time (last night for example)?
Any other suggestions?