|
|
|
SSC Rookie
 
Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 25,
Visits: 332
|
|
Hi All,
We have a database which has a missing NDF file. The drive which has the ndf file has failed and the database is not starting up because of the missing file on the drive. The NDF file has the indexes on the filegroup there is no data on the file. I wanted to try the steps in the mentioned the below article to bring the File Group index file group offline and bring back the database. create the indexes back again on the filegroup.
http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/9bc47b5b-7f10-4ff6-9547-c1a20391d29d/
but the problem i have faced while i was testing the approach that once i have bring the file group offine i cannot delete the file group i get the below error.
Cannot add, remove, or modify a file in filegroup 'hespofg' because
the filegroup is offline
http://www.megasolutions.net/Sqlserver/Cannot-remove-filegroup-69123.aspx
please advise if there is any option that i can bring the filegroup online or delete the filegroup after the database is backonline.
Thank in Advance.
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, January 26, 2012 9:50 AM
Points: 525,
Visits: 1,089
|
|
Hi,
In the msdn site they are just setting the file offline not the filegroup. Are you sure you are doing the same.
Thanks
Chandra Mohan N
Thanks
Chandra Mohan
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 25,
Visits: 332
|
|
Yes i am trying to set the lost ndf file offline. and try to bring the database online.
Thanks & Regards,
Rembersu
|
|
|
|
|
One Orange Chip
Group: Administrators
Last Login: Yesterday @ 4:06 PM
Points: 29,496,
Visits: 11,673
|
|
|
|
|
|
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 6:26 AM
Points: 30,280,
Visits: 23,051
|
|
Do you have a backup?
Gail Shaw
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 25,
Visits: 332
|
|
Thank you Steve for the link. from the article
"Note that once a file is set offline, the only way to set the file online is by restoring the file from backup. See “ALTER DATABASE MODIFY FILE” in Books Online for more information." - I don't file group backup for the database.
That means that i cannot bring back the file group online once we have changed it to offline.
If i don't bring the file offline i am not able to bring Database Partial Availability.
so my only option would be restore from the backup or bring the database Partial available and BCP out the data in the table and drop/re-create that database. Please advise
I have a backup full backup of the database. I was trying to restore the database to the point the drive of the index file group has crashed. I don't have the backup of the .ndf file.
|
|
|
|
|
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 6:26 AM
Points: 30,280,
Visits: 23,051
|
|
I would recommend that you restore the entire database. If you don't have a filegroup backup (and log backups from the time of the full), it's going to be hard to get that back without doing a full restore.
You do have log backups up to present?
Gail Shaw
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 25,
Visits: 332
|
|
thank you i think i have to go with the full backup  .no i don't have the T-log backup for the database.
|
|
|
|
