Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mehdin69
Starting Member
1 Post |
 Posted - 2014-02-27 : 13:46:28
|
| 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:\nvtndf.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?------OR 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 |
|
|
fan2005
Yak Posting Veteran
85 Posts |
Posted - 2015-03-03 : 01:59:34
|
| Hi, I have the same problem.did you find solution |
 |
|
|
Ganesh Kandi
Starting Member
4 Posts |
Posted - 2015-03-09 : 12:52:08
|
| No fan.Not yet.If any comments I'll post here.SQL Server DBA |
|
|
|
lusymare
Starting Member
1 Post |
Posted - 2015-04-16 : 12:33:34
|
| Have you verified that your server meets the minimum requirements for SQL Server 2012? Specifically, Processor, Memory, Drive Space, and OS?[url=http://www.solitaire-champ.com/klondike-solitaire.html]http://www.solitaire-champ.com/klondike-solitaire.html[/url] |
|
|
|
ScottPletcher
Aged Yak Warrior
550 Posts |
Posted - 2015-04-29 : 18:33:24
|
| You must always restore the primary filegroup, since that contains the metadata (table names, definitions, etc.).Is the db in simple recovery model? If so, you must recover all read-write filegroups; you can skip restoring only read-only filegroups. |
|
|
|
|
|
|
Restoring only one file group