Re: Remote Desktop

From: Mark Allison (marka_at_no.tinned.meat.mvps.org)
Date: 05/17/04 

Date: Mon, 17 May 2004 17:05:54 +0100

stonehead,

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

Relevant Pages

  • RE: List users mapped drives on a remote PC
    ... "Scott McWilliams" wrote: ... > Thanks ESP, ... > it was working but it was listing the local computer mapped drives. ... but not the drives mapped by the current user of the remote XP ...
    (microsoft.public.scripting.vbscript)
  • Re: ufsdump on remote tape drive.
    ... >> I have the network component. ... how were you going to restore box C if it dies? ... >can't do remote restores, AFAIK. ... One way is to boot from the install CD ...
    (comp.unix.solaris)
  • Re: Devices on remote machines
    ... WScript.Echo "You must enter the computer name when starting this script." ... WScript.Echo "Network printer mappings:" ... although I have full rights ont the remote machine ... have both mapped drives & network printers connected to their machine. ...
    (microsoft.public.scripting.vbscript)
  • RE: List users mapped drives on a remote PC
    ... hard disks) on the remote PCs but not the mapped shares. ... >> it was working but it was listing the local computer mapped drives. ... >> changes to a more Terminal Server-ish model where the WMI session on the ...
    (microsoft.public.scripting.vbscript)
  • Re: SQL Backup and Restore
    ... > the remote restore works great from query analyzer, but when i try to run ... >> You could create a job on your remote server that issues the restore ... When the backup job on the primary server is complete you can ...
    (microsoft.public.sqlserver.server)