Monday, March 12, 2012

Filegroup question

Hi
I have database with multiples files (.ndf) but it resides in one filegrp
which is PRIMARY.
If i wanted to restore, do i just perform restore from full backup. Any
additional steps since there are multiple files in that filegrp?
TIA"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:DE6A17FE-9030-44B1-987C-392D73B11C8B@.microsoft.com...
> Hi
> I have database with multiples files (.ndf) but it resides in one filegrp
> which is PRIMARY.
> If i wanted to restore, do i just perform restore from full backup. Any
> additional steps since there are multiple files in that filegrp?
> TIA
It depends on how you performed your backup. If you did a database backup,
then you simply need to perform a restore from that backup.
If you did a filegroup backup, (which you probably did not do as you only
have the default PRIMARY filegroup), then you could restore the filegroup
backup and rerun all logs since the filegroup backup occurred.
Rick Sawtell
MCT, MCSD, MCDBA

No comments:

Post a Comment