I have a very large database(150G) with two filegroups.
One of the most frequent operation on this database is
bulk insert. The Recovery model is set to Simple for
avoiding the log file to grow. Since the db is so big I
need to individualy backup each file group and, in case
something happens, to be able to restore one filegroup. My
problem is that since I cannot afford to have recovery
model FULL, I don't have all the log backups required in
order to restore only one filegroup. There is any solution
to this problem?
Thank you
What exactly is the reason you can't back up a 150GB db? Is it disk space?
You may want to check out a product called SQL LiteSpeed that can compress
your backups down to 70 or 80%.
Andrew J. Kelly SQL MVP
"Laura" <anonymous@.discussions.microsoft.com> wrote in message
news:90ba01c43300$ad2b9e30$a001280a@.phx.gbl...
> I have a very large database(150G) with two filegroups.
> One of the most frequent operation on this database is
> bulk insert. The Recovery model is set to Simple for
> avoiding the log file to grow. Since the db is so big I
> need to individualy backup each file group and, in case
> something happens, to be able to restore one filegroup. My
> problem is that since I cannot afford to have recovery
> model FULL, I don't have all the log backups required in
> order to restore only one filegroup. There is any solution
> to this problem?
> Thank you
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment