Re: db restoration via shared folder
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/23/04
- Next message: John Bell: "RE: Multiple SP Versions"
- Previous message: jen: "Copy DB,Packages etc to another computer .."
- In reply to: NG: "Re: db restoration via shared folder"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Mar 2004 09:56:27 +0100
> Based on the article, I was able to backup/restore db
> without any problem in MSSQL standard/enterprise edition.
I assume that you used Query Analyzer for this, is that what you mean?
> The point here is the article stated that backup/restore
> can't be done using Enterprise Manager. But I was able to
> backup/restore db using Enterprise Manager in Standard
> Edition but NOT Enterprise Edition. I was able to see the
> mapped drive in the Standard Edition. Why I unable to
> view the mapped drive in Enterprise Edition using the
> Enterprise Manager? Is this a special feature in Standard
> Edition or other setting need to be done here in order to
> do so in the Enterprise Edition?
I won't read the article, but just be aware that it might be incorrect. Back
to the problem. Here's what I think is going on:
On one installation, the service account is the same as the one you are
logged in as. Hence, the mapped drives are the same. On the other, you are
using different accounts. The key point here is that mapped drives are per
user. And typically, you are not logged in using the same account as the SQL
Server service account. So what you perceive as a mapped drive is different
to what SQL Server does.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "NG" <angiecmf@hotmail.com> wrote in message news:11e7e01c4107a$848e7680$a101280a@phx.gbl... > Let me rephrase my question here, Sorry if my explaination > was not clear earlier. > > Based on the article, I was able to backup/restore db > without any problem in MSSQL standard/enterprise edition. > The point here is the article stated that backup/restore > can't be done using Enterprise Manager. But I was able to > backup/restore db using Enterprise Manager in Standard > Edition but NOT Enterprise Edition. I was able to see the > mapped drive in the Standard Edition. Why I unable to > view the mapped drive in Enterprise Edition using the > Enterprise Manager? Is this a special feature in Standard > Edition or other setting need to be done here in order to > do so in the Enterprise Edition? Currently I am using > MSSQL 7 with sp(3) on NT4 (sp6). > > Your help is much appreciated. > > > >-----Original Message----- > >So, you made certain that the SQL Server service has > permissions on the > >share and it still didn't work? What error message did > you get? > > > >-- > >Tibor Karaszi, SQL Server MVP > >http://www.karaszi.com/sqlserver/default.asp > > > > > >"NG" <angiecmf@hotmail.com> wrote in message > >news:1101001c40fc1$4ab1af40$a501280a@phx.gbl... > >> I was reading the article on the subject above at the > >> http://dbforums.com/arch/178/2002/3/329543 > >> > >> The question here is:- > >> Testing was done and I was able to restore db using EM > on > >> a Standard Edition (SP3) and mapped drive to another > >> server. Unlike I was unable to do that from a > Enterprise > >> Edtion (SP3). Why is that so? > >> > >> Thanks. > > > > > >. > >
- Next message: John Bell: "RE: Multiple SP Versions"
- Previous message: jen: "Copy DB,Packages etc to another computer .."
- In reply to: NG: "Re: db restoration via shared folder"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
