Afficher un message
Vieux 11/09/2006, 15h58   #3
Sue Hoegemeier
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: SQL Server 2000 - Default path for data files

You pretty much don't want to use mapped drives for anything
in SQL Server. If you were using UNC paths, in that case
it's possible but not by default though - you need to use a
trace flag. And it isn't recommended. Whether supported or
not depends on the hardware. Generally, you really want to
be using DAS or SAN for the data and log files. You can find
the information on using network devices for data and log
files in the following article:
Description of support for network database files in SQL
Server
http://support.microsoft.com/?id=304261

-Sue

On Mon, 11 Sep 2006 07:16:02 -0700, Frank Goris <Frank
Goris@discussions.microsoft.com> wrote:

>Hello,
>
>I'm running into a problem on installing SQL Server 2000 Standard Edition.
>
>
>I want to install SQL Server on a server, let's say Server001 (Server is
>running windows sql server 2003).
>- The log files need to be located on the same server, so no problem.
>- The Data files need to be locates on an other server, let's say Server002,
>on a drive Z:\SQLData. If I try to redirect the path to an other drive, I
>only get local drives of Server001.
>
>Is this possible, and if possible, how ?
>
>Thanks for your replies.
>Frank


  Réponse avec citation
 
Page generated in 0,04752 seconds with 9 queries