Post reply

Please Help Urgent!! Recovery database from Missing NDF file.

  • February 9, 2009 at 9:10 pm

    #130833

    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.

  • February 9, 2009 at 10:06 pm

    #940955

    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

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • February 9, 2009 at 10:09 pm

    #940958

    Yes i am trying to set the lost ndf file offline. and try to bring the database online.

    Thanks & Regards,

    Rembersu

  • February 9, 2009 at 10:16 pm

    #940961

    Try this: http://sqlblog.com/blogs/linchi_shea/archive/2007/02/26/maintain-database-partial-availability.aspx

  • February 10, 2009 at 9:28 am

    #941359

    Do you have a backup?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

  • February 10, 2009 at 9:38 am

    #941374

    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.

  • February 10, 2009 at 9:47 am

    #941385

    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
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

  • February 10, 2009 at 9:52 am

    #941391

    thank you i think i have to go with the full backup :crying: .no i don't have the T-log backup for the database.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply