We are going to install SQL Server 2000 on Windows Server
2003. There are 2 disks C and D where D is a SAN.
We would like to know should we install SQL Server Program
on C or D Drive ? We suppose that we should install the
data on the D Drive.
Is there any requirement that the C or D drive has to be
NTFS ?
installation files on C
Data files in D
yes, it must be NTFS
"Mary" wrote:
> We are going to install SQL Server 2000 on Windows Server
> 2003. There are 2 disks C and D where D is a SAN.
> We would like to know should we install SQL Server Program
> on C or D Drive ? We suppose that we should install the
> data on the D Drive.
> Is there any requirement that the C or D drive has to be
> NTFS ?
>
>
|||Sir, you said that the drives must be NTFS. I have my SQL Server 2000
(Developers Edition) installed on XP Pro with both C and D drives formatted
FAT32 but I am unable to RESTORE previous user defined databases which I had
backed up when those two drives were NTFS. In Enterprise Manager, beside the
name of each of the three databases which I am trying to restore, are the
words (Loading\Suspect) and there are no items when I click on the plus sign
to expand these databases. Could this be causing my problem? I previously
had these two drives formatted NTFS but I have a Win98SE machine on a LAN
and it could not read the NTFS drives or files. So I changed them to FAT32
so that the 98SE machine could read the drives on the XP Pro machine. TIA,
Jim.
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:D1A511AE-736F-4543-87B8-E6F8750B43BB@.microsoft.com...[vbcol=seagreen]
> installation files on C
> Data files in D
> yes, it must be NTFS
> "Mary" wrote:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment