Reasons to restore individual file groups.

Hi,
I'm making the decision to not backup file groups and only backup databases (with backkup exec.
I don't see any reason I would have to resore individual file groups.
Does anyone know why I should backup file groups or in what situation I would need to restore individual file groups?Dont know your situation. If a user drops a table(which
typically the cant) you could restore it by itself if its
in its own filegroup.
>--Original Message--
>Hi,
>I'm making the decision to not backup file groups and
only backup databases (with backkup exec.)
>I don't see any reason I would have to resore individual
file groups.
>Does anyone know why I should backup file groups or in
what situation I would need to restore individual file
groups?
>.
>|||Chris,
I assume that you mean that the filegroup restore would help to restore only
that table to an earlier point in time? That is not possible as when you
restore a filegroup, you also have to apply all subsequent transaction log
backups.
However, I should hasten to add, in SQL2K, you can do a PARTIAL restore into
a new database and move that table to the production database. There are
restriction, however, like the primary filegroup has top be part of the
backup.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:b15301c3ecc9$e7651950$a101280a@.phx.gbl...
> Dont know your situation. If a user drops a table(which
> typically the cant) you could restore it by itself if its
> in its own filegroup.
>
> >--Original Message--
> >Hi,
> >I'm making the decision to not backup file groups and
> only backup databases (with backkup exec.)
> >I don't see any reason I would have to resore individual
> file groups.
> >Does anyone know why I should backup file groups or in
> what situation I would need to restore individual file
> groups?
> >.
> >|||Mannie,
The way I look at filegroup backup and restore is that I prefer to avoid it
if I can. If I have a database too large to handle with "regular" backup
methods, then I consider it. Just the fact that your database is toast if
you are missing one log backup taken after the filegroup you have restore
feel a bit scary to me.
I prefer to keep things as simple as possible. You can still use filegroups
and even do filegroup restore from a full backup (possibly using the PARTIAL
option of applicable).
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mannie" <anonymous@.discussions.microsoft.com> wrote in message
news:53DEF63A-8C4A-45A9-A48A-88A19688217D@.microsoft.com...
> Hi,
> I'm making the decision to not backup file groups and only backup
databases (with backkup exec.)
> I don't see any reason I would have to resore individual file groups.
> Does anyone know why I should backup file groups or in what situation I
would need to restore individual file groups?