Re: logical device already exists??
From: bing (bing_at_discussions.microsoft.com)
Date: 07/13/04
- Next message: David Browne: "Re: Optimizer chooses different plans"
- Previous message: bing: "Re: how to skip failed backup command?"
- In reply to: Hari Prasad: "Re: logical device already exists??"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 13 Jul 2004 10:14:01 -0700
Thanks all for the information. Very helpful.
Bing
"Hari Prasad" wrote:
> 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
>
>
>
- Next message: David Browne: "Re: Optimizer chooses different plans"
- Previous message: bing: "Re: how to skip failed backup command?"
- In reply to: Hari Prasad: "Re: logical device already exists??"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
