Re: db restoration via shared folder

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: NG (angiecmf_at_hotmail.com)
Date: 03/23/04


Date: Mon, 22 Mar 2004 17:59:46 -0800

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.
>
>
>.
>



Relevant Pages

  • Re: Please help: what version of SQL Do I have/need???
    ... It's Standard Edition ... Enterprise Manager. ... EM is just the GUI tool ... >that comes with SQL Server that allow you to administrate ...
    (microsoft.public.sqlserver.server)
  • Re: More than 2G of Ram
    ... The wierd thing is that enterprise manager says it can go up ... to 2G since that is all standard edition can support. ... Sql Server could not spawn process_loginread thread ... > allow sql to use memory above 2G? ...
    (microsoft.public.sqlserver.server)
  • Re: db restoration via shared folder
    ... > backup/restore db using Enterprise Manager in Standard ... > mapped drive in the Standard Edition. ... the mapped drives are the same. ...
    (microsoft.public.sqlserver.server)
  • Set restriction on Local Admin Account
    ... Operators with local admin right to production box ... - I need to restriction rights to those users with backup/restore only (in ... enterprise manager). ...
    (microsoft.public.sqlserver.server)