Re: Best way to install data files?
- From: Robert Porter <rhysliam@xxxxxxxxxxxxxx>
- Date: Wed, 08 Jun 2005 11:12:12 -0400
kvr901 wrote:
I am not sure I understand your concern about attached files. Once a database is mounted by the server accessing is no different than any other database on the server, regardless of the location of the actual physical data file.Thank you for your reply.
Another question:
**IF** some time in the future I decide to distribute the application including the distributable version of SQL Server (I believe it is called the "MSDE") would the installation procedure be the same?
In earlier versions of Access there was a considerable learning curve (coding) to use attached Access secured "backend" databases, and I am wondering if I should expect similar hurdles with the distributable version of SQL Server.
Thank you.
"Jacco Schalkwijk" wrote:
With the disk setup that server has, install the SQL Server executables on the RAID 1, and the user database on the RAID 5. You can create the master, model and msdb system databases on the RAID 1 as well, and the tempdb on RAID 1 as well, if there is enough space.
-- Jacco Schalkwijk SQL Server MVP
"kvr901" <kvr901@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E45F9F10-8B51-4644-A239-9A4F674BBFFD@xxxxxxxxxxxxxxxx
Warning beginner here.
I posted this in the setup news group but haven't received and replies, so perphaps someone here can help me.
I am developing a small ASP.NET web application that will use an SQL Server
2000 database. The database will start with 1,000 records in a main table
and about 100,000 records in a related table. How much this database will
grow is unknown.
I have one desktop machine that I am using for testing. It has one hard drive, and nothing special about it.
Another test machine will pretend to be a production server. It is a real
server. It has the operating (Win Server 2003) system on a RAID 1 (2 drives)
setup. It also has 6 other drives set up as a RAID 5.
Should SQL Server be installed on the RAID 1, and then install the data files only to the RAID 5? OR Should SQL Server and the data files be installed on the RAID 5 drive?
The reason I ask is.... From prior experience with Access I learned that although attached data files can be worked with, they often required much more code.
So.... What is the best way to do this? And... why?
TIA.
As to installing your database on a customers site. The issues around RAID are more data integrity and performance related. Whatever their configuration is will be dependent on the number of users and their pocket books. But the system will work on any platform that supports SQL Server.
.
- Prev by Date: Cannot See Database
- Next by Date: Re: Cannot See Database
- Previous by thread: Cannot See Database
- Next by thread: General Network Error - Windows 2003 SP1, SQL Server 2000 SP4
- Index(es):
Relevant Pages
|
