db restoration via shared folder

I was reading the article on the subject above at the
http://examnotes.net/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.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://examnotes.net/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.|||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...
on
Enterprise
>
>.
>|||> 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.
>
> permissions on the
> you get?
> on
> Enterprise

db file folder

hi. i'm new to sql server administration.
i've a instance whose default store folder is C:\SQLDB. i would like to
move the 3 databases that run on it to another harddrive. what's the
way to do this?
1) create backups of the 3 databases.
2) uninstall sqlserver
3) instal sqlserver with the store folder pointing to the new drive
4) restore the 3 databases?
seems like there should be a shorter way
thanx riyazHi
Actually , you have two options ( mabe more , i'd prefer those two)
1) BACKUP DATABASE and RESTORE ... WITH MOVE options (for more details
please refer to BOL)
2) sp_detach_db , then move the .MDF,LDF files to the new location and them
issue sp_attach_db stored procedure
<rmanchu@.gmail.com> wrote in message
news:1146990766.264052.197800@.y43g2000cwc.googlegroups.com...
> hi. i'm new to sql server administration.
> i've a instance whose default store folder is C:\SQLDB. i would like to
> move the 3 databases that run on it to another harddrive. what's the
> way to do this?
> 1) create backups of the 3 databases.
> 2) uninstall sqlserver
> 3) instal sqlserver with the store folder pointing to the new drive
> 4) restore the 3 databases?
> seems like there should be a shorter way
> thanx riyaz
>|||I'd recommend that you use the detach/attach method. You should make sure
that you backup the machine before doing this, just to be on the safe side.
SSMS and Enterprise manager allow you to control the detach and attach
process really well, so if you're doing this as a one of just use the front
end tools. If you need to do lots of severs which are configured the same,
then script the commands from the tools as this will save time later.
Regards
Colin Dawson
www.cjdawson.com
<rmanchu@.gmail.com> wrote in message
news:1146990766.264052.197800@.y43g2000cwc.googlegroups.com...
> hi. i'm new to sql server administration.
> i've a instance whose default store folder is C:\SQLDB. i would like to
> move the 3 databases that run on it to another harddrive. what's the
> way to do this?
> 1) create backups of the 3 databases.
> 2) uninstall sqlserver
> 3) instal sqlserver with the store folder pointing to the new drive
> 4) restore the 3 databases?
> seems like there should be a shorter way
> thanx riyaz
>