April 3, 2010 at 2:23 pm
Hi,
We have sql server 2005 EE x64 with SP3. For our production database, we have 1 mdf file & 7 ndf files of equal size in single Primary file group on different disks. This is Share point content database and we can have only single Primary file group.
If one of the ndf file corrupts, then can we restore the database from the backup and bring the database online?
April 3, 2010 at 4:14 pm
If you lose an NDF, if it's in a separate filegroup and you have performed filegroup backups, you can restore just that one, potentially.
If you lose an NDF, likely you are restoring from a full backup.
April 4, 2010 at 6:46 am
gmamata7 (4/3/2010)
Hi,We have sql server 2005 EE x64 with SP3. For our production database, we have 1 mdf file & 7 ndf files of equal size in single Primary file group on different disks. This is Share point content database and we can have only single Primary file group.
If one of the ndf file corrupts, then can we restore the database from the backup and bring the database online?
If I understand your question correctly, I think you are asking whether you could perform an online restore. The answer is no, since online restore requires that the PRIMARY file group be fully online.
Sadly, the restrictions placed on you by SharePoint prevent you from taking advantage of this very cool feature of SQL Server Enterprise Edition.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply