Re: logical device already exists??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 21:27:57 +0530

Hi,

It seems there is an entry in master..sysdevices table.

Execute the below procedure from Query ANalyzer and ensure that you do not
have the same file.

sp_helpdevice

To double check the same by querying :-

select * from master..sysdevices

If you have an entry then you can drop the device by using the below command
(Execute the comand if you need)

sp_dropdevice 'device_name'

Thanks
Hari
MCDBA

Thanks
Hari
MCDBA

"bing" <bing@discussions.microsoft.com> wrote in message
news:9AC7B842-64A8-4790-8C39-87957075EE39@microsoft.com...
> I want to back the master db to the disk file
e:\data\MSSQL\BACKUP\master.BAK.
>
> When I tried to create a new backup device called 'master', I got the
error:
>
> Error 15026: Logical device 'master' already exists.
>
> But I've checked several times and don't see master.BAK already exist in
e:\data\MSSQL\BACKUP. I had no problem creating the backup devices for
other system default databases, like msdb, model, etc.
>
> Anybody know what might be the problem?
>
> Bing

Relevant Pages

  • Iptables action Return; Resolved automatic Static routes - Thanks
    ... My thanks to Ed Wilts for helping me to enable static routes ... Edited with entry for instance: ... worked to make the scripts execute automatic. ...
    (RedHat)
  • Re: Novice - Yeah, see my SEE SEE
    ... primitives, how do you redefine the primitive in terms ... The words execute faster ... I'm better at assembler than Forth;-) ... First entry: Pointer to previous word in the dictionary ...
    (comp.lang.forth)
  • Re: Novice - Yeah, see my SEE SEE
    ... primitives, how do you redefine the primitive in terms ... The words execute faster ... I'm better at assembler than Forth;-) ... First entry: Pointer to previous word in the dictionary ...
    (comp.lang.forth)
  • Want telnetd to execute different program than default (/bin/login)
    ... I would like my fedora core 1 system to execute a program other than ... When I change the entry in /etc/xinetd.d/telnet to furnish the command ... I got this error message: ... I tried enclosing the server argument in quotes: ...
    (comp.os.linux.misc)
  • Re: "What she said!"
    ... items high and the list is several hundred items long and you've ... when the drop-down box appears, type the first letter of ... the entry you're looking for...most browsers will immediately jump to the first ... What good is being an executive if you never get to execute anyone? ...
    (alt.usage.english)