I'm using SQL 2008 R2 Enterprise and yesterday I had an hardware-error. During this error one disk went offline, which contains a very unimportant part (filegroup) of the database. Accidentially this part was stored only on one single disk which failed.
To minimize the outtage we decided to set the missing filegroup OFFLINE and started over. At the evening I tried to rebuild the database, but I failed.
My problem is the following
- The filegroup is offline
- The tables from these filegroup are orphaned
- I'm unable to delete these orphaned tables, because filegroup is offline
- I've restored a backup from two days ago with a fully functional database
- I've tried to restore the missing filegroup from backup DB to production DB, but the database-file stucks in state "RESTORING" (sys.database_files)
- so I'm unable to restore these filegroup
- I'd be very satisfied when I'm able to kill these filegroup and recreate the necessary tables from backup
Does anyone know a way to get out of this crisis?
Thanks in advance :)