• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 594
  • Last Modified:

Backup Job Error MSSQL 2000

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.
0
Carla Romere
Asked:
Carla Romere
2 Solutions
 
MrAliCommented:
You have an object called 'tagit' as a backup device in that SQL Server, but you do not have a object called 'claims_dev'.  You can substitute 'claims_dev' with the file path you wish to use, or if you find out what file path claims_dev is supposed to use, you can recreate it. Basically, you just need to find out what path you need before you can do anything with it.

http://msdn.microsoft.com/en-us/library/ms179313.aspx
0
 
25112Commented:
you need to use the following system procedure to add CLAIMS_DEV as a recognizable device, like TagIt

USE master;
GO
EXEC sp_addumpdevice 'disk', 'CLAIMS_DEV', 'c:\locationhere\backname.bak';

http://msdn.microsoft.com/en-us/library/ms188409.aspx

--------------------------
you can check the devices that are registered from
select * from master..sysdevices
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now