Can't Create Backup Device. Error 15026

  • Error 15026: Logical device 'master' already exists.

    I'm getting the above error message trying to create a Backup Device called "master" for SQL Server 2000 SP3a. It's a new db server that I've just brought online. I've barely attached some db to this server and was getting ready to create a backup job to backup the msdb and master databases. I do not see "master" as a device in Enterprise Manager. I've deleted all the backup devices that is listed in "Management | Backup" in Enterprise Manager and it's still giving me the above error.

    It works if I create "master2", but I really would like to use "master" as the backup device name. Does anyone know how to fix this?

    Thanks.

  • Ignore the above.

    I've used TSQL to delete this invisible backup device:

    sp_dropdevice 'master'

    It's odd that it's not showing though...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply