backup SQL Server 2005

I want to know how can I make the daily backup of SQL Server on a backup media?

1. what files I should backup?

2. Do I have stop all connections during backup or it's possibel to take it online?

No need to stop the connection or take database offline. SQL Server can take backup online.

Use this query

Backup Database Yourdatabasename To Disk='D:\YourBackupfile.bak'

read more about Backup / Restore Database in BOL (books online - help for sql server)

Madhu

|||Here's a technet article that describes backup and restore in SQL Server 2000.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx