install multiple database on one sql server

Hi,
I am planning to have 3 (app) database intalled on one sql 2000 server, what
is the best way/s to do this?
Thanks.
You could either locate all databases on the one server or install multiple
instances with each DB in its own instance. I don't really see any need for
instances though as its 6 of one or half dozen of the other. I've ran with
30+ dbs on one instance in a production environment.
"anoni" wrote:

> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server, what
> is the best way/s to do this?
> Thanks.
|||Hi,
All depends up on the resource usage for your individual application and SQL
Server edition you are going to use.
If it is enterprise edition on a Windows Advanced server you could add more
RAM (> 4 GB) and enable AWE.
After that you can have 3 databases in the same database instance.
Incase if your resource usage is less and number of concurrent users are
less then you could go for SQL Server standard edition with 2 GB of RAM
in Server and have all the 3 databases in same database instance.
Note:-
For installing multiple instance:- For each instance you need to get
seperate SQL server License.
Thanks
Hari
SQL Server MVP
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:C4E730EA-3A96-45E5-B3F5-0197749958FE@.microsoft.com...
> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server,
> what
> is the best way/s to do this?
> Thanks.
|||As long as Server is capable of handling the work, put multiple DBs in a
single instance of SQL... Maintenance is easier..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:C4E730EA-3A96-45E5-B3F5-0197749958FE@.microsoft.com...
> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server,
> what
> is the best way/s to do this?
> Thanks.
sql

install multiple database on one sql server

Hi,
I am planning to have 3 (app) database intalled on one sql 2000 server, what
is the best way/s to do this?
Thanks.You could either locate all databases on the one server or install multiple
instances with each DB in its own instance. I don't really see any need for
instances though as its 6 of one or half dozen of the other. I've ran with
30+ dbs on one instance in a production environment.
"anoni" wrote:
> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server, what
> is the best way/s to do this?
> Thanks.|||Hi,
All depends up on the resource usage for your individual application and SQL
Server edition you are going to use.
If it is enterprise edition on a Windows Advanced server you could add more
RAM (> 4 GB) and enable AWE.
After that you can have 3 databases in the same database instance.
Incase if your resource usage is less and number of concurrent users are
less then you could go for SQL Server standard edition with 2 GB of RAM
in Server and have all the 3 databases in same database instance.
Note:-
For installing multiple instance:- For each instance you need to get
seperate SQL server License.
Thanks
Hari
SQL Server MVP
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:C4E730EA-3A96-45E5-B3F5-0197749958FE@.microsoft.com...
> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server,
> what
> is the best way/s to do this?
> Thanks.|||As long as Server is capable of handling the work, put multiple DBs in a
single instance of SQL... Maintenance is easier..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:C4E730EA-3A96-45E5-B3F5-0197749958FE@.microsoft.com...
> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server,
> what
> is the best way/s to do this?
> Thanks.

install multiple database on one sql server

Hi,
I am planning to have 3 (app) database intalled on one sql 2000 server, what
is the best way/s to do this?
Thanks.You could either locate all databases on the one server or install multiple
instances with each DB in its own instance. I don't really see any need for
instances though as its 6 of one or half dozen of the other. I've ran with
30+ dbs on one instance in a production environment.
"anoni" wrote:

> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server, wh
at
> is the best way/s to do this?
> Thanks.|||Hi,
All depends up on the resource usage for your individual application and SQL
Server edition you are going to use.
If it is enterprise edition on a Windows Advanced server you could add more
RAM (> 4 GB) and enable AWE.
After that you can have 3 databases in the same database instance.
Incase if your resource usage is less and number of concurrent users are
less then you could go for SQL Server standard edition with 2 GB of RAM
in Server and have all the 3 databases in same database instance.
Note:-
For installing multiple instance:- For each instance you need to get
seperate SQL server License.
Thanks
Hari
SQL Server MVP
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:C4E730EA-3A96-45E5-B3F5-0197749958FE@.microsoft.com...
> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server,
> what
> is the best way/s to do this?
> Thanks.|||As long as Server is capable of handling the work, put multiple DBs in a
single instance of SQL... Maintenance is easier..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:C4E730EA-3A96-45E5-B3F5-0197749958FE@.microsoft.com...
> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server,
> what
> is the best way/s to do this?
> Thanks.

Inside MDF file

Hi,
Is there any place where I can learn about the internal structure of a typical database file MDF ?
I'm not planning to do a competitor product Just want to know how it is internally organized.
Any link, articles, books recommendations are welcome.
Thanks,
"Inside SQL Server 2000" is a good start.
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,
|||Hi,
Have a look into the below link:-
http://msdn.microsoft.com/library/de...us/architec/8_
ar_da2_9sab.asp
Thanks
Hari
MCDBA
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,
|||Inside SQL Server 2000 by Kalen Delaney is one of the best books on the
subject. Books online has some information and Ken Henderson's Guru's Guide
to SQL Server Architecture looks promising (although I have not yet added
this one to my library).
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,

Inside MDF file

Hi
Is there any place where I can learn about the internal structure of a typical database file MDF
I'm not planning to do a competitor product :) Just want to know how it is internally organized
Any link, articles, books recommendations are welcome
Thanks,"Inside SQL Server 2000" is a good start.
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product :) Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Hi,
Have a look into the below link:-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_da2_9sab.asp
Thanks
Hari
MCDBA
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product :) Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Inside SQL Server 2000 by Kalen Delaney is one of the best books on the
subject. Books online has some information and Ken Henderson's Guru's Guide
to SQL Server Architecture looks promising (although I have not yet added
this one to my library).
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product :) Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,

Inside MDF file

Hi,
Is there any place where I can learn about the internal structure of a typic
al database file MDF ?
I'm not planning to do a competitor product Just want to know how it is i
nternally organized.
Any link, articles, books recommendations are welcome.
Thanks,"Inside SQL Server 2000" is a good start.
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Hi,
Have a look into the below link:-
http://msdn.microsoft.com/library/d...-us/architec/8_
ar_da2_9sab.asp
Thanks
Hari
MCDBA
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Inside SQL Server 2000 by Kalen Delaney is one of the best books on the
subject. Books online has some information and Ken Henderson's Guru's Guide
to SQL Server Architecture looks promising (although I have not yet added
this one to my library).
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,