how to do a complete backup of SQL Server 2000

Hi,
we are starting to deploy SQL Server 2000 and in the SQL
Server Book it said that regular backups of SQL Server are
important in order to delete transaction logs.
I have done a backup of 2 of our databases, but the
transaction logs remain the same size - why is that?
The second thing I would like to ask, is backup possible
only for single databases? And how can I for example
backup the security logins,...?
Thanks for reply.
Bodo> I have done a backup of 2 of our databases, but the
> transaction logs remain the same size - why is that?
A backup of the database does nothing to the data within the transaction
log, you need to issue backup log command for this. If you do not require
transactional recovery, set your database to simple recovery mode.
> The second thing I would like to ask, is backup possible
> only for single databases?
Yes, backup database, see "BACKUP, BACKUP (described)" in BOL for syntax
>And how can I for example
> backup the security logins,...?
This page is the best for that, it will script the permissions, users, etc.
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"bodo" <bodobecker@.hotmail.com> wrote in message
news:019001c370c4$60f81d80$a501280a@.phx.gbl...
> Hi,
> we are starting to deploy SQL Server 2000 and in the SQL
> Server Book it said that regular backups of SQL Server are
> important in order to delete transaction logs.
> I have done a backup of 2 of our databases, but the
> transaction logs remain the same size - why is that?
> The second thing I would like to ask, is backup possible
> only for single databases? And how can I for example
> backup the security logins,...?
> Thanks for reply.
> Bodo