I am a rookie and need help in backing up data

[hkjamjam]

I am using SQL Server 2000 Enterprise Version on W2k, with a IBM LTO tape
drive,
I got a question about backup the database, I schedule the task in window to
backup at mid night and it runs, but it doesn't backup the database, is it
becuase the SQL Is In Use? I can backup folders file by this method, So what
should I do?
I am using W2K internal Backup application.

Extra question: I have a production server which is in another domain, can I
backup it too??I cann get connect to the server to back up it.

 

[Jeff Cochran]

I am using SQL Server 2000 Enterprise Version on W2k, with a IBM LTO tape
drive,
I got a question about backup the database, I schedule the task in window to
backup at mid night and it runs, but it doesn't backup the database, is it
becuase the SQL Is In Use? I can backup folders file by this method, So what
should I do?
I am using W2K internal Backup application.

Use the SQL Backup, bets accessed through the maintenance wizard. You
can back to tape, or to a backup folder that you back up to tape in
the normal fashion. Pay attention to transaction logs as well, SQL
backups are an art to themselves.

Jeff