I'm trying to build a new cluster with SQL Server 2K Enterprise on
Windows 2003 server. When I run the install, I tell it to put the
program files on the D: (local) drive and the data/log files on shared
drives. However, after the installation is complete, almost all the
files go in the C: drive in \program files\Microsoft SQL Server, rather
than the D: drive (it does create a few files on D:). We've experienced
this on more than one server build.
Anyone know any way around this?
Post answers publicly, please, or email to
steven.wechsler (at)mtvstaff.co m (the posting email address is hosed).
Thanks,
Steve 1 1637
I don't know much about clustering myself, however this KB article
notes that in SQL 2000, only databases are failed over, not binaries,
so in order for setup to install the binaries, "you must ensure that
each node has a local drive letter in common with all the other nodes
in the cluster". Is it possible that only some nodes have a D: drive? http://support.microsoft.com/default...b;en-us;243218
In any case, it would probably be worth giving Microsoft a call - I
guess that if you have the requirement and the resources to implement
clustering, then the cost of a support call is negligible (if you don't
already have a general support agreement). And if the issue is caused
by a bug in the product, then it's free anyway.
Simon This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ken Lindner |
last post by:
I have a need to become familiar with SQL Server 2000 for work.
Needless to say I am new to SQL Server any version, but not IT in
general. My employer has provided me with the SQL Server 2000
Personal disk from the SQL Server 2000 Enterprise kit as this is
reported here on the MSDN web site to be the version that is supported
on Windows XP. In fact so many of you kind people confess to having
succeeded in doing it.
I have tried...
|
by: nt |
last post by:
I am having a problem with a regular backup of an SQL Server (MSDE
2000) database to a local drive. I initiate the backup once a week, by
issuing the required T-SQL, via ADO. In this case, the T-SQL is:
BACKUP DATABASE GPRS_Dimensioning_Archive TO local_backup WITH
RETAINDAYS=21, NAME='GDA_20040706'
Note that "local_backup" is a file sitting on the same physical drive
as the database itself, and has > 80 GB free. It is not a RAID...
|
by: Chris Gatto |
last post by:
Hello,
My organization is currently considering the purchase of a new intranet
application server and we are looking for opinions from those who have been
down this road before. In brief the server must support the following:
- 600+ users using various ASP.Net based applications, only 2 currently but
growing over time as old legacy apps are converted;
- Some applications are mission critical, others not so much;
- DB back-end is a...
|
by: Dan Lorenz |
last post by:
When trying to use the function CreateDirectory on my local machine
everything works fine but when I upload the page to my webhost I get an issue
that it can't find path on D:\, though D:\ is what my website is found on.
This is an H-SPHERE web cluster host.
From my research I found that this issue is due to ASPNET account not having
read previdgeles on the root of the drive.
My question is what is the correct approach to solve this...
|
by: Simon |
last post by:
Hi All,
I'm hoping someone will have some words of wisdom for me regarding MS
Clustering on Windows 2003.
I have a service that runs on a cluster. During invocation it's
supposed to determine from the cluster which node is active (this is a
active/standby configuration) and either proceed or sleep depending on
the status. The interface to the cluster is that advertised by the
standard interop layer built by Visual Studio for the...
| |
by: lesperancer |
last post by:
I've got an access97 reporting mdb that pulls data (77,000 rows) from a
sql server table into a local table to run reports
if the local table is part of the reporting MDB, the insert statement
(16 fields) takes less than 30secs, but because of db-bloat, I moved
the local table to a 2nd MDB
and per postings, this 2nd MDB is copied into a folder and linked as a
'temp' MDB every time I run my reporting mdb
|
by: =?Utf-8?B?S2Vubnk=?= |
last post by:
I have one bat file that contains a command to startup Java Program. Then, I
would like to create a cluster job to call the bat file. In case of one
computer is down, another computer can also call the bat file and startup my
Java Program.
For this purpose, I have tried to place the bat file into share drive of two
computers which are cluster machine. Also, I used Generic Application to
create a job to call my bat file and this job is...
|
by: naspinski |
last post by:
Ok, this is the second install I haev tried of 2005 to get this right, and something is not working correctly. The server is in a cluster, and it has 4 drives available in the cluster... the N Drive is supposed to be the Data drive, and during install, I specify it as such, but when I get it installed, the L drive shows up as the data drive.
Now, I figured that wasn't a huge problem, so I clicked on the DB and hit properties and went to...
|
by: Mark D Powell |
last post by:
I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit)
to SQL Severer 2005 EE 32 bit and while the prereqs passed the
installer will not let me select the version 8.00.x (2000 SP4)
database that it finds on the server.
When I ckeck the install details it tells me that
"Your upgrade is blocked becuase of cluster upgrade rules"
I have tried searching the MS site but none of the entries I found
appear to apply.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |