SQL Server Performance

Restoring only one file group

Discussion in 'ALL SQL SERVER QUESTIONS' started by Mehdin69, Feb 27, 2014.

  1. Mehdin69 New Member

    I have created the file group for my database.First i took backup of individual file group(mdf and ndf) then I tried to restore only secondary(ndf) file group.I got error like
    Restore failed for Server 'pcname\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
    File 'regSQL_dat' was not backed up in file 1 on device 'D:vtndf.bak'. The file cannot be restored from this backup set.
    RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3144)

    When i tried to restore only primary file group i got the same error.

    Can i restore individual file group? If possible then how?


    For the purpose of data archiveng,i have taken back up of ndf file (it contains very old data) & i have removed this file from database.Now my customer asking these file data.Now i have to again attach/restore this ndf file.Please let me know how to attach/restore.

    Thank you

Share This Page