backup files

Hello,
Could someone tell me which files i definitly need to backup in sql server
2000. I know i need to backup the master.mdf, but do i also need the
master.trn? If so, why.
Greetings,
ZekeFirst off you should not backup at the file level as the resulting backup
may not be transactionally consistent or useable to restore. There is a
backup command in SQL Server that you use to produce a file(s). Check out
the BACKUP and RESTORE commands in BooksOnLine for more information. This
may be useful as well:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx
Andrew J. Kelly SQL MVP
"Ezekiël" <ezekiel@.lycos.nl> wrote in message
news:u7cPkz7bEHA.2972@.TK2MSFTNGP12.phx.gbl...
> Hello,
> Could someone tell me which files i definitly need to backup in sql server
> 2000. I know i need to backup the master.mdf, but do i also need the
> master.trn? If so, why.
> Greetings,
> Zeke
>