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)
  • Query regarding cron jobs
    ... I have a file created in /etc/cron.d which has an entry which execute a ... But due to some reason it is not getting executed and the entry is still ... and/or attachments to it are strictly prohibited. ...
    (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)
  • 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)