sql 2000 server to a backup pc

[phaldisa]

Hi can you please supply a script to create a backup device on a remote backup pc, and the scrip to run the backup.
I am new to SQL server and are reading and learning as much as I can to help me.Can this be automated to run daily as well??

thanks

Phaldie
South Africa

 

[tlbroadbent]

BACKUP DATABASE pubs
TO DISK = '\\server\share\sqlbackup\pubs_db.bak'
WITH INIT

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm