Posted by rcamarda on 08/15/07 14:01

Look into Enterprise Manager, Maintenance Plan Wizard. It will help
you with various tasks including backups.
In my backup jobs, I first perform a log backup then a full backup.
This will keep the size of the transaction log in check as it gets
truncated during this process. (Assuming the database is in FULL and
not SIMPLE. Check the properties of the database via EM).

I found that when I only did a full backup, my transaction log kept
growing.
MC2
Rob

On Aug 14, 10:49 pm, scott s <scott.str...@gmail.com> wrote:
> Hello all, I was just awarded the job of maintaing the database server
> for our company. I have basically ZERO experience using MS SQL Server
> 2000. Can anyone point me in the direction of a good resource for
> creating backups of our database? I would love something that comes
> with a gui that really simplifies the process; seeing as how i have
> never even opened the MS SQL program.
>
> Our database is fairly small we have 7 users with access to the
> database. That is it.
>
> any advice or good resources would be greatly appreciated.

[Back to original message]