I am currently taking a class on SQL Server 2000. Part of my assignment is to do a full backup of the Northwind databse use TSQL. I've typed the code below, but am receiving an error when I try to run it. Can anyone help me with this or guide me in the right direction? I am clueless as to why this code will not run.
--Full backup of the Northwind database.
--Name backup "RhondaColeman_WindBackup_TSQL"
BACKUP DATABASE Northwind TO NWbackup
NAME = 'RhondaColeman_WindBackup_TSQL',
DESCRIPTION = 'Full backup of Northwind Database using TSQL'
****Error I am recieving*****
Server: Msg 3206, Level 16, State 1, Line 5
No entry in sysdevices for backup device 'NWbackup'. Update sysdevices and rerun statement.
Server: Msg 3013, Level 16, State 1, Line 5
BACKUP DATABASE is terminating abnormally.