Hi
When I go to restore db in SQL 2000 using 'Remote Desktop' I can only see local drives and not mapped drives. When I go physically to the computer I can see the local and mapped drives when trying to restore db. This leads me to belive it is a 'Remote Desktop' issue
Any suggestions
Thanks in advancestonehead,
Why not just use Enterprise Manager, or even better, Query Analyzer from
your client workstation to do the restore? Do you need to use Remote
Desktop? Do you have a roaming profile on the domain? If you map the drives
using Remote Desktop, log off and then log on again, do they still
disappear?
When restoring over the network, you should always use a UNC name anyway, as
this reduces exposure to bugs. Mapped drive letters can change, or even
disappear. Try using a UNC name, i.e.
\\servername\share\folder\file
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"stonehead" <anonymous@.discussions.microsoft.com> wrote in message
news:9261C67A-2A59-452B-9129-FEF7DADC6EC9@.microsoft.com...
> Hi,
> When I go to restore db in SQL 2000 using 'Remote Desktop' I can only see
local drives and not mapped drives. When I go physically to the computer I
can see the local and mapped drives when trying to restore db. This leads
me to belive it is a 'Remote Desktop' issue.
> Any suggestions?
> Thanks in advance
No comments:
Post a Comment