create new db

Greetings,
Using a server base database called Respond (fe) and Sql server 2000 as a (be), I was trying to create a new db. Instead of designing from scratch, I was thinking to copy an existing Respond db, delete existing data, and modify it to fit my new requirements. I'm new to sql server db and would like to know
1. How to delete data from the table (be).
2. How to perform an automatic backup daily (or may be every other day) and how to check if the backup is doing what it was suppose to do in sql server 2000.

Thank you in advance,

OCMOCM, this is really basic stuff. Delete data by either issueing a DELETE sql command or a TRUNCATE TABLE sql command. Backups can easily be automated through the Enterprise Manager console.
You need to avail yourself of the wealth of information in Microsoft SQL Server Books Online.|||OCM, this is really basic stuff. Delete data by either issueing a DELETE sql command or a TRUNCATE TABLE sql command. Backups can easily be automated through the Enterprise Manager console.
You need to avail yourself of the wealth of information in Microsoft SQL Server Books Online.|||Backups can easily be automated through the Enterprise Manager console. :)

You just had to tell him that didn't you. :) You can also schedule a job to do them. Check out this weblog: http://weblogs.sqlteam.com/tarad