|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > db complete backup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
db complete backup
|
|
|
| Hi,
we just lost our dba. I would like somebody give me more
information about Database Maintenance Plan. How to manage
it, how to create, etc.
I have such a plan in production. It will have complete
backup every week on wed and sun midnight. the data file
size (i mean webdb_Data.MDF if i am right) is less then
2G, but the backup file is 6.5G, so it eats up space so
quickly. why is it so big? How can I deal with it? Delete
the old backup by hand periodicaly?
Thanks
| |
| Geoff N. Hiten 2002-10-05, 9:16 pm |
| Read BOL topic Backup and Restore. (BOL is Books On-Line, the SQL server
documentation) It will explain pretty much everything about how backups
work. Once you are familiar with that, then the maintenance plans will make
sense. I suggest getting some temporary expertise while you either grow or
find a replacement DBA. It is almost certainly cheaper than losing your
data.
--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Jen" <follower1999@yahoo.com> wrote in message
news:a78c01c265bf$6a8a90a0$3be
f2ecf@TKMSFTNGXA10...
> Hi,
> we just lost our dba. I would like somebody give me more
> information about Database Maintenance Plan. How to manage
> it, how to create, etc.
> I have such a plan in production. It will have complete
> backup every week on wed and sun midnight. the data file
> size (i mean webdb_Data.MDF if i am right) is less then
> 2G, but the backup file is 6.5G, so it eats up space so
> quickly. why is it so big? How can I deal with it? Delete
> the old backup by hand periodicaly?
> Thanks
|
|
|
|
|