No login name for restored database users

If I restore a database to a different server it restores
the name of the users but not the Login Name.
How can I restore or copy the users to the destination
server?
Thanks in advance.
Pete.This page will help
http://support.microsoft.com/defaul...kb;en-us;246133
Ray Higdon MCSE, MCDBA, CCNA
--
"Pete" <anonymous@.discussions.microsoft.com> wrote in message
news:086b01c3c480$b2604f20$a301280a@.phx.gbl...

quote:

---

> If I restore a database to a different server it restores
> the name of the users but not the Login Name.
> How can I restore or copy the users to the destination
> server?
> Thanks in advance.
> Pete.

---

|||Perfect!
Thanks for the response, merry christmas.
Pete.

quote:

---

>--Original Message--
>This page will help
>http://support.microsoft.com/default.aspx?scid=kb;en-

---

us;246133

quote:

---

>
>--
>Ray Higdon MCSE, MCDBA, CCNA
>--
>"Pete" <anonymous@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:086b01c3c480$b2604f20$a301280a@.phx.gbl...
restores[QUOTE]
>
>.
>

---

No disk activity during database restore

I am trying to restore a 200 GB database on to a newly formatted SAN
volume. The restore has been running for hours but there doesn't seem
to be a lot of disk activity on the disks I'm restoring to and I'm
wondering if that's anything to worry about.
Using perfmon I'm monitoring the % Disk time for the disk I'm restoring
to. It will show around 99% for a minute or so and then drop to zero
for 3-4 minutes. Is this normal? I know that since I'm restoring to a
new volume that SQL Server needs to zero out the 200 GB before it
starts the actual restore but I would expect to see 100% disk time
while it does this.
Any insight appreciated.
Thanks!
Hi , Can you watch i/o in sysprocesses table for the SPID running the backup
task , this should be changing ...
Vishal
"pshroads@.gmail.com" wrote:

> I am trying to restore a 200 GB database on to a newly formatted SAN
> volume. The restore has been running for hours but there doesn't seem
> to be a lot of disk activity on the disks I'm restoring to and I'm
> wondering if that's anything to worry about.
> Using perfmon I'm monitoring the % Disk time for the disk I'm restoring
> to. It will show around 99% for a minute or so and then drop to zero
> for 3-4 minutes. Is this normal? I know that since I'm restoring to a
> new volume that SQL Server needs to zero out the 200 GB before it
> starts the actual restore but I would expect to see 100% disk time
> while it does this.
> Any insight appreciated.
> Thanks!
>
|||Hi
I see this all the time. Even the IO stats and SPID stats show that nothing
is happening, but it is.
The issue is that before the actual restore can take place, the DB needs to
be created and initialized. This is an operation that SQL Server calls the
OS to do via an API. As the OS just indicates that the operation is still
running, the IO and SPID counter do not change.
The SAN has the instruction, and is doing the hard work. The OS and in turn
SQL Server are waiting for the SAN to finish.
If you were to have 200GB cache on the SAN, the SAN would return almost
immediately and then flush the pages to disk, but you probably don't have so
much, the disk IO is still happening at SAN level.
Deepening on the SAN configuration, 200GB could take anywhere from a few
seconds to a few hours.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vishal Gandhi" <VishalGandhi@.discussions.microsoft.com> wrote in message
news:007A4393-EE3D-4360-98B6-23A5C949FE17@.microsoft.com...[vbcol=seagreen]
> Hi , Can you watch i/o in sysprocesses table for the SPID running the
> backup
> task , this should be changing ...
> Vishal
>
> "pshroads@.gmail.com" wrote:
|||Thanks for your reply. Even though SQL Server passes the task off to
the OS I'm still not sure why I don't see continual disk activity. Why
would I see a minute or two of activity followed by a few minutes of no
activity?
Thanks
|||Hi
Have a look at the SAN management that your SAN vendor supplies. It will
give a you a good idea what is really happening in it.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<pshroads@.gmail.com> wrote in message
news:1119646132.436946.57570@.g14g2000cwa.googlegro ups.com...
> Thanks for your reply. Even though SQL Server passes the task off to
> the OS I'm still not sure why I don't see continual disk activity. Why
> would I see a minute or two of activity followed by a few minutes of no
> activity?
> Thanks
>

No disk activity during database restore

I am trying to restore a 200 GB database on to a newly formatted SAN
volume. The restore has been running for hours but there doesn't seem
to be a lot of disk activity on the disks I'm restoring to and I'm
wondering if that's anything to worry about.
Using perfmon I'm monitoring the % Disk time for the disk I'm restoring
to. It will show around 99% for a minute or so and then drop to zero
for 3-4 minutes. Is this normal? I know that since I'm restoring to a
new volume that SQL Server needs to zero out the 200 GB before it
starts the actual restore but I would expect to see 100% disk time
while it does this.
Any insight appreciated.
Thanks!Hi , Can you watch i/o in sysprocesses table for the SPID running the backup
task , this should be changing ...
Vishal
"pshroads@.gmail.com" wrote:
> I am trying to restore a 200 GB database on to a newly formatted SAN
> volume. The restore has been running for hours but there doesn't seem
> to be a lot of disk activity on the disks I'm restoring to and I'm
> wondering if that's anything to worry about.
> Using perfmon I'm monitoring the % Disk time for the disk I'm restoring
> to. It will show around 99% for a minute or so and then drop to zero
> for 3-4 minutes. Is this normal? I know that since I'm restoring to a
> new volume that SQL Server needs to zero out the 200 GB before it
> starts the actual restore but I would expect to see 100% disk time
> while it does this.
> Any insight appreciated.
> Thanks!
>|||Hi
I see this all the time. Even the IO stats and SPID stats show that nothing
is happening, but it is.
The issue is that before the actual restore can take place, the DB needs to
be created and initialized. This is an operation that SQL Server calls the
OS to do via an API. As the OS just indicates that the operation is still
running, the IO and SPID counter do not change.
The SAN has the instruction, and is doing the hard work. The OS and in turn
SQL Server are waiting for the SAN to finish.
If you were to have 200GB cache on the SAN, the SAN would return almost
immediately and then flush the pages to disk, but you probably don't have so
much, the disk IO is still happening at SAN level.
Deepening on the SAN configuration, 200GB could take anywhere from a few
seconds to a few hours.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vishal Gandhi" <VishalGandhi@.discussions.microsoft.com> wrote in message
news:007A4393-EE3D-4360-98B6-23A5C949FE17@.microsoft.com...
> Hi , Can you watch i/o in sysprocesses table for the SPID running the
> backup
> task , this should be changing ...
> Vishal
>
> "pshroads@.gmail.com" wrote:
>> I am trying to restore a 200 GB database on to a newly formatted SAN
>> volume. The restore has been running for hours but there doesn't seem
>> to be a lot of disk activity on the disks I'm restoring to and I'm
>> wondering if that's anything to worry about.
>> Using perfmon I'm monitoring the % Disk time for the disk I'm restoring
>> to. It will show around 99% for a minute or so and then drop to zero
>> for 3-4 minutes. Is this normal? I know that since I'm restoring to a
>> new volume that SQL Server needs to zero out the 200 GB before it
>> starts the actual restore but I would expect to see 100% disk time
>> while it does this.
>> Any insight appreciated.
>> Thanks!
>>|||Thanks for your reply. Even though SQL Server passes the task off to
the OS I'm still not sure why I don't see continual disk activity. Why
would I see a minute or two of activity followed by a few minutes of no
activity?
Thanks|||Hi
Have a look at the SAN management that your SAN vendor supplies. It will
give a you a good idea what is really happening in it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<pshroads@.gmail.com> wrote in message
news:1119646132.436946.57570@.g14g2000cwa.googlegroups.com...
> Thanks for your reply. Even though SQL Server passes the task off to
> the OS I'm still not sure why I don't see continual disk activity. Why
> would I see a minute or two of activity followed by a few minutes of no
> activity?
> Thanks
>

No disk activity during database restore

I am trying to restore a 200 GB database on to a newly formatted SAN
volume. The restore has been running for hours but there doesn't seem
to be a lot of disk activity on the disks I'm restoring to and I'm
wondering if that's anything to worry about.
Using perfmon I'm monitoring the % Disk time for the disk I'm restoring
to. It will show around 99% for a minute or so and then drop to zero
for 3-4 minutes. Is this normal? I know that since I'm restoring to a
new volume that SQL Server needs to zero out the 200 GB before it
starts the actual restore but I would expect to see 100% disk time
while it does this.
Any insight appreciated.
Thanks!Hi , Can you watch i/o in sysprocesses table for the SPID running the backup
task , this should be changing ...
Vishal
"pshroads@.gmail.com" wrote:

> I am trying to restore a 200 GB database on to a newly formatted SAN
> volume. The restore has been running for hours but there doesn't seem
> to be a lot of disk activity on the disks I'm restoring to and I'm
> wondering if that's anything to worry about.
> Using perfmon I'm monitoring the % Disk time for the disk I'm restoring
> to. It will show around 99% for a minute or so and then drop to zero
> for 3-4 minutes. Is this normal? I know that since I'm restoring to a
> new volume that SQL Server needs to zero out the 200 GB before it
> starts the actual restore but I would expect to see 100% disk time
> while it does this.
> Any insight appreciated.
> Thanks!
>|||Hi
I see this all the time. Even the IO stats and SPID stats show that nothing
is happening, but it is.
The issue is that before the actual restore can take place, the DB needs to
be created and initialized. This is an operation that SQL Server calls the
OS to do via an API. As the OS just indicates that the operation is still
running, the IO and SPID counter do not change.
The SAN has the instruction, and is doing the hard work. The OS and in turn
SQL Server are waiting for the SAN to finish.
If you were to have 200GB cache on the SAN, the SAN would return almost
immediately and then flush the pages to disk, but you probably don't have so
much, the disk IO is still happening at SAN level.
Deepening on the SAN configuration, 200GB could take anywhere from a few
seconds to a few hours.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vishal Gandhi" <VishalGandhi@.discussions.microsoft.com> wrote in message
news:007A4393-EE3D-4360-98B6-23A5C949FE17@.microsoft.com...[vbcol=seagreen]
> Hi , Can you watch i/o in sysprocesses table for the SPID running the
> backup
> task , this should be changing ...
> Vishal
>
> "pshroads@.gmail.com" wrote:
>|||Thanks for your reply. Even though SQL Server passes the task off to
the OS I'm still not sure why I don't see continual disk activity. Why
would I see a minute or two of activity followed by a few minutes of no
activity?
Thanks|||Hi
Have a look at the SAN management that your SAN vendor supplies. It will
give a you a good idea what is really happening in it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<pshroads@.gmail.com> wrote in message
news:1119646132.436946.57570@.g14g2000cwa.googlegroups.com...
> Thanks for your reply. Even though SQL Server passes the task off to
> the OS I'm still not sure why I don't see continual disk activity. Why
> would I see a minute or two of activity followed by a few minutes of no
> activity?
> Thanks
>

No Access to mapped drives

Hi,
I have a Wndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me )
Thanks in advance,
Olaf
Hi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me )
> Thanks in advance,
> Olaf
>
|||Hari,
thanks for the quick reply, but:
the sql server account does have full permissions as it is the domain admin
account. Also, I do not want to use an UNC path, but a mapped drive. The
other sql server I mentioned does show the mapped drives in Enterprise
Manager.
Anyway, thx
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Start the SQL Server service using a Domain user which has got rights in
> remote server share. After that you will be able to access the remot path
> from query analyzer.
> backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
with[vbcol=seagreen]
> init
> Note:-
> Enterprise manager will not show the mapped drives
>
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
do[vbcol=seagreen]
> a
error[vbcol=seagreen]
> medium
> all.
> the
security[vbcol=seagreen]
> server.
sql[vbcol=seagreen]
> sql
identically,
> accessing
>
|||Hi,
Can you try this from query analyzer:-
xp_cmdshell 'net use k: \\remoteserver\share'
(No need of specifying user name and password , becuase u are starting sql
server in domain admin user)
The above command will map the drive k:, now try
Backup database dbname to disk='k:\dbname.bak' with init
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> Hari,
> thanks for the quick reply, but:
> the sql server account does have full permissions as it is the domain
admin[vbcol=seagreen]
> account. Also, I do not want to use an UNC path, but a mapped drive. The
> other sql server I mentioned does show the mapped drives in Enterprise
> Manager.
> Anyway, thx
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
path[vbcol=seagreen]
> with
> do
> error
in[vbcol=seagreen]
> security
the[vbcol=seagreen]
> sql
or[vbcol=seagreen]
> identically,
UNC
>
|||Hi,
yes, this works fine, thanks.
Anyway, I am wondering why the other sql server in our domain can access the
mapped drives without doing anything. Maybe this is a bug ..?
Thanks,
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi,
> Can you try this from query analyzer:-
> xp_cmdshell 'net use k: \\remoteserver\share'
> (No need of specifying user name and password , becuase u are starting sql
> server in domain admin user)
> The above command will map the drive k:, now try
> Backup database dbname to disk='k:\dbname.bak' with init
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> admin
in[vbcol=seagreen]
> path
to[vbcol=seagreen]
or[vbcol=seagreen]
at[vbcol=seagreen]
> in
account[vbcol=seagreen]
> the
the[vbcol=seagreen]
the[vbcol=seagreen]
Security
> or
> UNC
>
|||Hi,
Thats good. I am not sure about the error.
Are you running this command from server or from a client PC using a Query
analyzer. If it is client PC you need to
map the drive from query analyzer. If you are executing from server that
command is suppose to work directly.
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:espbrftUEHA.1036@.TK2MSFTNGP12.phx.gbl...
> Hi,
> yes, this works fine, thanks.
> Anyway, I am wondering why the other sql server in our domain can access
the[vbcol=seagreen]
> mapped drives without doing anything. Maybe this is a bug ..?
> Thanks,
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
sql[vbcol=seagreen]
The[vbcol=seagreen]
rights[vbcol=seagreen]
> in
disk='\\remoteserver\backupshare\dbname.bak'[vbcol=seagreen]
possible[vbcol=seagreen]
> to
an[vbcol=seagreen]
> or
shown[vbcol=seagreen]
> at
drives[vbcol=seagreen]
> account
to[vbcol=seagreen]
sql[vbcol=seagreen]
so[vbcol=seagreen]
> the
> the
> Security
an
>

No Access to mapped drives

Hi,
I have a Wndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me )
Thanks in advance,
OlafHi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me )
> Thanks in advance,
> Olaf
>

No Access to mapped drives

Hi,
I have a Wndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me )
Thanks in advance,
OlafHi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me )
> Thanks in advance,
> Olaf
>|||Hari,
thanks for the quick reply, but:
the sql server account does have full permissions as it is the domain admin
account. Also, I do not want to use an UNC path, but a mapped drive. The
other sql server I mentioned does show the mapped drives in Enterprise
Manager.
Anyway, thx
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Start the SQL Server service using a Domain user which has got rights in
> remote server share. After that you will be able to access the remot path
> from query analyzer.
> backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
with
> init
> Note:-
> Enterprise manager will not show the mapped drives
>
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
do[vbcol=seagreen]
> a
error[vbcol=seagreen]
> medium
> all.
> the
security[vbcol=seagreen]
> server.
sql[vbcol=seagreen]
> sql
identically,[vbcol=seagreen]
> accessing
>|||Hi,
Can you try this from query analyzer:-
xp_cmdshell 'net use k: \\remoteserver\share'
(No need of specifying user name and password , becuase u are starting sql
server in domain admin user)
The above command will map the drive k:, now try
Backup database dbname to disk='k:\dbname.bak' with init
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> Hari,
> thanks for the quick reply, but:
> the sql server account does have full permissions as it is the domain
admin
> account. Also, I do not want to use an UNC path, but a mapped drive. The
> other sql server I mentioned does show the mapped drives in Enterprise
> Manager.
> Anyway, thx
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
path[vbcol=seagreen]
> with
> do
> error
in[vbcol=seagreen]
> security
the[vbcol=seagreen]
> sql
or[vbcol=seagreen]
> identically,
UNC[vbcol=seagreen]
>|||Hi,
yes, this works fine, thanks.
Anyway, I am wondering why the other sql server in our domain can access the
mapped drives without doing anything. Maybe this is a bug ..?
Thanks,
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Can you try this from query analyzer:-
> xp_cmdshell 'net use k: \\remoteserver\share'
> (No need of specifying user name and password , becuase u are starting sql
> server in domain admin user)
> The above command will map the drive k:, now try
> Backup database dbname to disk='k:\dbname.bak' with init
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> admin
in[vbcol=seagreen]
> path
to[vbcol=seagreen]
or[vbcol=seagreen]
at[vbcol=seagreen]
> in
account[vbcol=seagreen]
> the
the[vbcol=seagreen]
the[vbcol=seagreen]
Security[vbcol=seagreen]
> or
> UNC
>|||Hi,
Thats good. I am not sure about the error.
Are you running this command from server or from a client PC using a Query
analyzer. If it is client PC you need to
map the drive from query analyzer. If you are executing from server that
command is suppose to work directly.
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:espbrftUEHA.1036@.TK2MSFTNGP12.phx.gbl...
> Hi,
> yes, this works fine, thanks.
> Anyway, I am wondering why the other sql server in our domain can access
the
> mapped drives without doing anything. Maybe this is a bug ..?
> Thanks,
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
sql[vbcol=seagreen]
The[vbcol=seagreen]
rights[vbcol=seagreen]
> in
disk='\\remoteserver\backupshare\dbname.bak'[vbcol=seagreen]
possible[vbcol=seagreen]
> to
an[vbcol=seagreen]
> or
shown[vbcol=seagreen]
> at
drives[vbcol=seagreen]
> account
to[vbcol=seagreen]
sql[vbcol=seagreen]
so[vbcol=seagreen]
> the
> the
> Security
an[vbcol=seagreen]
>

No access at sql 2000 DB after restore on an other sql server

HI,
i've some trouble with a sql server 2000 db.
the db uses sql server auth
i make a backup from the DB and take the backup to an other sqlserver, i had
restored the database at ther new server.
i've create ^the db owner user on the new server and executed
sp_change_users_login 'Update_One', 'username', 'loginname'
now my asp .net application works fine. but i would like to modify some
tables from the DB if, i start query analyzer and login as the db owner and
start a query
select *
rom issues
at the restored db i recieved an error
"Server: Nachr.-Nr. 208, Schweregrad 16, Status 1, Zeile 1
Ungültiger Objektname 'issues'." means the Object issues is invalid, but th
e
table exists. the same query on the original db Server is ok i recieved the
right result
whats wrong?
Many Thanks for your helpflabs (flabs@.discussions.microsoft.com) writes:
> i've some trouble with a sql server 2000 db.
> the db uses sql server auth
> i make a backup from the DB and take the backup to an other sqlserver, i
> had restored the database at ther new server.
> i've create ^the db owner user on the new server and executed
> sp_change_users_login 'Update_One', 'username', 'loginname'
> now my asp .net application works fine. but i would like to modify some
> tables from the DB if, i start query analyzer and login as the db owner
> and start a query
> select *
> rom issues
> at the restored db i recieved an error
> "Server: Nachr.-Nr. 208, Schweregrad 16, Status 1, Zeile 1
> Ungltiger Objektname 'issues'." means the Object issues is invalid, but
> the table exists. the same query on the original db Server is ok i
> recieved the right result
Apparently your default schema on the server is not the schema where the
issues table is, nor is the table in the default schema of dbo. Note that
on SQL 2000 the default schema for a user is always the username.
It's not clear to me whether you did an sp_changedbowner of the database,
but you should probably have done that.
Run this query:
SELECT user_name(uid), *
FROM sysobjects
WHERE name= 'issues'
This should give you the owner/schema for the issues table.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hej
no, i didn't run sp_changedbowner. why must i run the sp ?
the result of SELECT user_name(uid), *
geminiuser issues 341576255 U 5 26 1610620982 64 0 0 2006-08-11
16:02:18.570 0 64 0 U 1 8291 0 2006-08-11 16:02:18.570 0 0 0 0 0 18433 0
i find out, if i run select *
from geminiuser.issues i recieved the right result
run i only issues without geniniuser. before issue i recieved an error.
what happens if i run sp_changeDBowner, sure i think it change the owner of
the db? but some else?
must i change all tables, add prefix geminiuser. in my sql script, i don't
like this.
"Erland Sommarskog" wrote:

> flabs (flabs@.discussions.microsoft.com) writes:
> Apparently your default schema on the server is not the schema where the
> issues table is, nor is the table in the default schema of dbo. Note that
> on SQL 2000 the default schema for a user is always the username.
> It's not clear to me whether you did an sp_changedbowner of the database,
> but you should probably have done that.
> Run this query:
> SELECT user_name(uid), *
> FROM sysobjects
> WHERE name= 'issues'
> This should give you the owner/schema for the issues table.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||flabs (flabs@.discussions.microsoft.com) writes:
> no, i didn't run sp_changedbowner. why must i run the sp ?
> the result of SELECT user_name(uid), *
> geminiuser issues 341576255 U 5 26 1610620982
> 64 0 0 2006-08-11
> 16:02:18.570 0 64 0 U 1 8291 0 2006-08-11
> 16:02:18.570 0 0 0 0 0 18433 0
> i find out, if i run select *
> from geminiuser.issues i recieved the right result
> run i only issues without geniniuser. before issue i recieved an error.
> what happens if i run sp_changeDBowner, sure i think it change the owner
> of the db? but some else?
> must i change all tables, add prefix geminiuser. in my sql script, i don't
> like this.
The simplest is if you run with a user that has geminiuser as its default
schema. On SQL 2000, this means that you should run as geminiuser.
I don't know which login you are logged in as, but this login needs to
map to geminiuser. Note that if the login geminiuser owns the database,
the login geminiuser maps to the user dbo.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx