I'm revising and verifying all of our backups jobs on one of our mssql 2000 servers.
This command works:
BACKUP DATABASE [TagIt] TO [TagIt] WITH INIT , NOUNLOAD , NAME = N'Comp backup TagIt', NOSKIP , STATS = 10, NOFORMAT
This one does not:
BACKUP DATABASE [CLAIMS_DEV] TO [CLAIMS_DEV] WITH INIT , NOUNLOAD , NAME = N'Comp backup CLAIMS_DEV', NOSKIP , STATS = 10, NOFORMAT
They are on the same server, backing up to the same location on a local drive. The error that I get on the second one is:
No entry in sysdevices for backup device 'CLAIMS_DEV'. Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206) BACK DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.