Installing Multiple Instances Design Question

I have 4 small small SQL 2000 databases that I need to consolidate to a
single machine.
The data is minimal maybe 100 GB total with an expection of some
moderate growth.
The box will be configured with a raid 5.
Question:
Should the O.S and each instance be on its own partition?
Or would it be better to have the instances on one partition and
dedicate a partition for the data and log files?
Any inforomation would be greatly appreciated.
Thanks,
HulicatI would investigate if the four database could reside in the same server.
(Perhaps because of security or other needs, that is not possible.)
If you have to have 'separate' servers, install multiple instances of SQL
Server on the same box. All instances will use the same OS -the only thing
being 'duplicated' is SQL Server instances (code, settings, etc.)
Drives.
Best choice: RAID 1 for OS and SQL installables (2 drives). RAID 10 for data
files (4 drives). RAID 10 for Logs files (4 drives). For optimal
performance, each instance 'should' have its own drives for data and logs.
I wouldn't recommend trying to make everything work with a single RAID 5.
That would be painful.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1162403869.339729.318940@.e64g2000cwd.googlegroups.com...
>I have 4 small small SQL 2000 databases that I need to consolidate to a
> single machine.
> The data is minimal maybe 100 GB total with an expection of some
> moderate growth.
> The box will be configured with a raid 5.
> Question:
> Should the O.S and each instance be on its own partition?
> Or would it be better to have the instances on one partition and
> dedicate a partition for the data and log files?
> Any inforomation would be greatly appreciated.
> Thanks,
> Hulicat
>|||~Thanks~
Arnie Rowland wrote:
> I would investigate if the four database could reside in the same server.
> (Perhaps because of security or other needs, that is not possible.)
> If you have to have 'separate' servers, install multiple instances of SQL
> Server on the same box. All instances will use the same OS -the only thing
> being 'duplicated' is SQL Server instances (code, settings, etc.)
> Drives.
> Best choice: RAID 1 for OS and SQL installables (2 drives). RAID 10 for data
> files (4 drives). RAID 10 for Logs files (4 drives). For optimal
> performance, each instance 'should' have its own drives for data and logs.
> I wouldn't recommend trying to make everything work with a single RAID 5.
> That would be painful.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Hulicat" <dennis_A_white@.yahoo.com> wrote in message
> news:1162403869.339729.318940@.e64g2000cwd.googlegroups.com...
> >I have 4 small small SQL 2000 databases that I need to consolidate to a
> > single machine.
> > The data is minimal maybe 100 GB total with an expection of some
> > moderate growth.
> >
> > The box will be configured with a raid 5.
> >
> > Question:
> > Should the O.S and each instance be on its own partition?
> > Or would it be better to have the instances on one partition and
> > dedicate a partition for the data and log files?
> >
> > Any inforomation would be greatly appreciated.
> >
> > Thanks,
> > Hulicat
> >

Installing full text index on SQL Server

A couple of years ago our ISP installed SQL Server 2000 single
processor licence on our server in their data centre.
They omitted to turn on indexing, or install full text indexing.
This was fine, but now we need to use it.
Is there any way that we can install full text indexing on the server
remotely using scripts to create the relevent stored procedures etc?
Or will we have to send the disk back to the data center so they can
put it in the server for us?
If this is the case and we re-insert the disk, what would be the effect
on the server of putting the disk back in (remembering that this is a
live server with several web sites hosted on it)? Would a new instance
be created? master databases over written etc? or would it be just fine
and the new services be added without any problems?
Any help, links, kb refs etc greatly appreciated
Paul R.sp_fulltext_database 'enable'
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"thoades@.hotmail.com" wrote:
> A couple of years ago our ISP installed SQL Server 2000 single
> processor licence on our server in their data centre.
> They omitted to turn on indexing, or install full text indexing.
> This was fine, but now we need to use it.
> Is there any way that we can install full text indexing on the server
> remotely using scripts to create the relevent stored procedures etc?
> Or will we have to send the disk back to the data center so they can
> put it in the server for us?
> If this is the case and we re-insert the disk, what would be the effect
> on the server of putting the disk back in (remembering that this is a
> live server with several web sites hosted on it)? Would a new instance
> be created? master databases over written etc? or would it be just fine
> and the new services be added without any problems?
> Any help, links, kb refs etc greatly appreciated
> Paul R.
>|||Many thanks Paul, that was exactly what I needed.
usefull examples also found here
http://sqljunkies.com/How%20To/E823E84B-C443-4483-B4A3-CEF80EB34CB1.scuk
Pr.
Paul Zanbaka wrote:
> sp_fulltext_database 'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
> "thoades@.hotmail.com" wrote:
> > A couple of years ago our ISP installed SQL Server 2000 single
> > processor licence on our server in their data centre.
> >
> > They omitted to turn on indexing, or install full text indexing.
> >
> > This was fine, but now we need to use it.
> >
> > Is there any way that we can install full text indexing on the server
> > remotely using scripts to create the relevent stored procedures etc?
> >
> > Or will we have to send the disk back to the data center so they can
> > put it in the server for us?
> >
> > If this is the case and we re-insert the disk, what would be the effect
> > on the server of putting the disk back in (remembering that this is a
> > live server with several web sites hosted on it)? Would a new instance
> > be created? master databases over written etc? or would it be just fine
> > and the new services be added without any problems?
> >
> > Any help, links, kb refs etc greatly appreciated
> >
> > Paul R.
> >
> >|||Anytime Paul
Check out my site
http://www.mycodekb.com/
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
"thoades@.hotmail.com" wrote:
> Many thanks Paul, that was exactly what I needed.
> usefull examples also found here
> http://sqljunkies.com/How%20To/E823E84B-C443-4483-B4A3-CEF80EB34CB1.scuk
> Pr.
> Paul Zanbaka wrote:
> > sp_fulltext_database 'enable'
> > --
> > Paul Zanbaka
> > Sharepoint Adminstrator and DBA
> > www.mycodekb.com
> >
> >
> > "thoades@.hotmail.com" wrote:
> >
> > > A couple of years ago our ISP installed SQL Server 2000 single
> > > processor licence on our server in their data centre.
> > >
> > > They omitted to turn on indexing, or install full text indexing.
> > >
> > > This was fine, but now we need to use it.
> > >
> > > Is there any way that we can install full text indexing on the server
> > > remotely using scripts to create the relevent stored procedures etc?
> > >
> > > Or will we have to send the disk back to the data center so they can
> > > put it in the server for us?
> > >
> > > If this is the case and we re-insert the disk, what would be the effect
> > > on the server of putting the disk back in (remembering that this is a
> > > live server with several web sites hosted on it)? Would a new instance
> > > be created? master databases over written etc? or would it be just fine
> > > and the new services be added without any problems?
> > >
> > > Any help, links, kb refs etc greatly appreciated
> > >
> > > Paul R.
> > >
> > >
>

Installation of Multiple named instances in Cluster environment

Hi All..

We are planning to build a cluster environment on MS SQL 2005. We want to install multiple named instances in a single database server and use cluster for that database server.

Is this option possible ? Any relevant documentation would be helpful

Thanks in advance

Regards

Madhav

Yes, you can install multiple instances of SQL Server into a cluster. All of the relevant information can be found in Books Online.|||

here is some supplemental information to Books Online that was recently published:

SQL Server Failover Clustering White Paper
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en