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?
thanksBackup to a UNC share that the account that SQL Server is running under has
access to.
BACKUP DATABASE master TO DISK = '\\SomeServer\SomeShare\master.bak' WITH
INIT
RESTORE DATABASE foo FROM DISK = '\\SomeServer\SomeShare\foo.bak' ...
--
Keith
"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|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment