Re: network drives

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 08:48:07 -0500

I agree with Keith, use UNC names, but the reason is that drive mappings
occur when someone logs on to the server... So what if someone else (with
different drive mappings) , logs on to the server, and now your backups
either fail, or go to Hoboken?...

UNC names prevent those kinds of problems from occurring..

Hope this helps... 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"milosmaj" <milosmaj@discussions.microsoft.com> wrote in message
news:B9EBA86D-EB0F-4844-BB89-534D3C9BA8A9@microsoft.com...
> i have several sql servers 2000 sp3.
> all have several network drives mapped.
> on some i can't browse to those drives when trying to backup or restore
> databases.
> basically i will only see local drives.
> how do i make sql server see mapped drives?
> thanks

Relevant Pages

  • Re: Hardware + Exchange 2003
    ... I will put the log files on the mirrored 36gb drives, ... the logs ... > created and what the allocation unit size is. ... > recommend building the server through a process that results in a 4K ...
    (microsoft.public.exchange.setup)
  • Re: Add new cluster and use existing LUNs?
    ... > Even a SAN has a maximum I/O capacity. ... you can share a LUN with more than one server. ... > Microsoft SQL Server MVP ... >> The first 5 drives of our SAN share the system binaries, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Add new cluster and use existing LUNs?
    ... Even a SAN has a maximum I/O capacity. ... you can share a LUN with more than one server. ... Microsoft SQL Server MVP ... > The first 5 drives of our SAN share the system binaries, ...
    (microsoft.public.sqlserver.clustering)
  • Re: After manually undoing a recent MS Update, my server is a mess
    ... Keep in mind that I have seen OEM drivers up there so given that you've blown that image away, I can't say for certain that the 'critical' was 100% pushed by Microsoft. ... External USB is no replacement for local drives. ... LOL I show my naivety here when I say that I showed great diligence in my blind application of any MS suggested resolution to "Critical Errors" on my Small Business Server Monitor Report. ... When I got the first BSOD, I booted from the orginal CD and chose to only restore the System files. ...
    (microsoft.public.windows.server.sbs)
  • Re: After manually undoing a recent MS Update, my server is a mess
    ... information to login to my server remotely to look around--hoping he could ... External USB is no replacement for local drives. ... stored on) and chose to only restore the System files. ... The "Cases" drive was actually a shared folder on an external ...
    (microsoft.public.windows.server.sbs)