|
|
You're in the
sql server replication
group:using minimal sql server as subscriber
sql server replication:
Absolutely - a lot of people use MSDE or SQL Express precisely for this
reason. -- Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Roy Goldhammer" <roy@hotmail.com> wrote in message news:umukisuyHHA.1188@TK2MSFTNGP04.phx.gbl... > Hello there > > I create new transactional replication envirnment. > > If some server is being used as subsriber only as part of replication and > no data is being changed there, Can i install minimal sql server on that > server without many functionalitiys that normal server needs like: > Locking, Agent, ect... in order to reduce the resources sql server use? >
Hello there
I create new transactional replication envirnment. If some server is being used as subsriber only as part of replication and no data is being changed there, Can i install minimal sql server on that server without many functionalitiys that normal server needs like: Locking, Agent, ect... in order to reduce the resources sql server use?
Whell Hilary.
Will msde or sql express can support database in 20Gb size and the performance on this subscriber won't be hurm? if so it can be best solution. Also when the data and the application are at the same computer the speed of givinig data will be better. Is it true? and will it also be true if the subscribers will be in windows cluster? [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:uiyh9vuyHHA.4928@TK2MSFTNGP03.phx.gbl... > Absolutely - a lot of people use MSDE or SQL Express precisely for this > reason. > > -- > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > "Roy Goldhammer" <roy@hotmail.com> wrote in message > news:umukisuyHHA.1188@TK2MSFTNGP04.phx.gbl... >> Hello there >> >> I create new transactional replication envirnment. >> >> If some server is being used as subsriber only as part of replication and >> no data is being changed there, Can i install minimal sql server on that >> server without many functionalitiys that normal server needs like: >> Locking, Agent, ect... in order to reduce the resources sql server use? >> > >
No you are limited to database data files up to 4 gigs in size. There is
nothing to stop you from having multiple databases. You can't really cluster MSDE or SQL Express. -- Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Roy Goldhammer" <roy@hotmail.com> wrote in message news:OslBUD4yHHA.484@TK2MSFTNGP06.phx.gbl... > Whell Hilary. > > Will msde or sql express can support database in 20Gb size and the > performance on this subscriber won't be hurm? if so it can be best > solution. Also when the data and the application are at the same computer > the speed of givinig data will be better. > > Is it true? and will it also be true if the subscribers will be in windows > cluster? > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:uiyh9vuyHHA.4928@TK2MSFTNGP03.phx.gbl... >> Absolutely - a lot of people use MSDE or SQL Express precisely for this >> reason. >> >> -- >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> "Roy Goldhammer" <roy@hotmail.com> wrote in message >> news:umukisuyHHA.1188@TK2MSFTNGP04.phx.gbl... >>> Hello there >>> >>> I create new transactional replication envirnment. >>> >>> If some server is being used as subsriber only as part of replication >>> and no data is being changed there, Can i install minimal sql server on >>> that server without many functionalitiys that normal server needs like: >>> Locking, Agent, ect... in order to reduce the resources sql server use? >>> >> >> > >
Exelly hilary. I've alread figured at out.
Here is my problem: today the application and the database are not in the same computer (Front end and back end) It seems that the chippest way is to place copy of each database on any computer at the front end. and update it by transactional replication. But it is clear that it will reduce the performance of the application server. eventhough all the application servers are in windows cluster. if it is correct?, can i set sql server with database as subcriber on server as part of windows cluatering? [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:%23KXlI75yHHA.1212@TK2MSFTNGP05.phx.gbl... > No you are limited to database data files up to 4 gigs in size. There is > nothing to stop you from having multiple databases. > > You can't really cluster MSDE or SQL Express. > -- > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > "Roy Goldhammer" <roy@hotmail.com> wrote in message > news:OslBUD4yHHA.484@TK2MSFTNGP06.phx.gbl... >> Whell Hilary. >> >> Will msde or sql express can support database in 20Gb size and the >> performance on this subscriber won't be hurm? if so it can be best >> solution. Also when the data and the application are at the same computer >> the speed of givinig data will be better. >> >> Is it true? and will it also be true if the subscribers will be in >> windows cluster? >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:uiyh9vuyHHA.4928@TK2MSFTNGP03.phx.gbl... >>> Absolutely - a lot of people use MSDE or SQL Express precisely for this >>> reason. >>> >>> -- >>> Looking for a SQL Server replication book? >>> http://www.nwsu.com/0974973602.html >>> >>> Looking for a FAQ on Indexing Services/SQL FTS >>> http://www.indexserverfaq.com >>> "Roy Goldhammer" <roy@hotmail.com> wrote in message >>> news:umukisuyHHA.1188@TK2MSFTNGP04.phx.gbl... >>>> Hello there >>>> >>>> I create new transactional replication envirnment. >>>> >>>> If some server is being used as subsriber only as part of replication >>>> and no data is being changed there, Can i install minimal sql server on >>>> that server without many functionalitiys that normal server needs like: >>>> Locking, Agent, ect... in order to reduce the resources sql server use? >>>> >>> >>> >> >> > >
So let me see if I have it right this time. You have a bunch of Front End
servers that are clustered. You have a backend SQL server. You want to place SQL Servers on your clusters and have them replicated to the backend. You have two options, create SQL Server clusters on the front end and have them replicate to the backend. Or create a standalones SQL Server on your clustered nodes and have it replicate to the backend. I think you are choosing the later. I think you should post this question to windows clustering or SQL Clustering. I don't know if it will work of not, but it is a non-standard way of doing it. -- Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Roy Goldhammer" <roy@hotmail.com> wrote in message news:Os8EOT6yHHA.1188@TK2MSFTNGP04.phx.gbl... > Exelly hilary. I've alread figured at out. > > Here is my problem: > > today the application and the database are not in the same computer (Front > end and back end) > > It seems that the chippest way is to place copy of each database on any > computer at the front end. and update it by transactional replication. > But it is clear that it will reduce the performance of the application > server. eventhough all the application servers are in windows cluster. > > if it is correct?, can i set sql server with database as subcriber on > server as part of windows cluatering? > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:%23KXlI75yHHA.1212@TK2MSFTNGP05.phx.gbl... >> No you are limited to database data files up to 4 gigs in size. There is >> nothing to stop you from having multiple databases. >> >> You can't really cluster MSDE or SQL Express. >> -- >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> "Roy Goldhammer" <roy@hotmail.com> wrote in message >> news:OslBUD4yHHA.484@TK2MSFTNGP06.phx.gbl... >>> Whell Hilary. >>> >>> Will msde or sql express can support database in 20Gb size and the >>> performance on this subscriber won't be hurm? if so it can be best >>> solution. Also when the data and the application are at the same >>> computer the speed of givinig data will be better. >>> >>> Is it true? and will it also be true if the subscribers will be in >>> windows cluster? >>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>> news:uiyh9vuyHHA.4928@TK2MSFTNGP03.phx.gbl... >>>> Absolutely - a lot of people use MSDE or SQL Express precisely for this >>>> reason. >>>> >>>> -- >>>> Looking for a SQL Server replication book? >>>> http://www.nwsu.com/0974973602.html >>>> >>>> Looking for a FAQ on Indexing Services/SQL FTS >>>> http://www.indexserverfaq.com >>>> "Roy Goldhammer" <roy@hotmail.com> wrote in message >>>> news:umukisuyHHA.1188@TK2MSFTNGP04.phx.gbl... >>>>> Hello there >>>>> >>>>> I create new transactional replication envirnment. >>>>> >>>>> If some server is being used as subsriber only as part of replication >>>>> and no data is being changed there, Can i install minimal sql server >>>>> on that server without many functionalitiys that normal server needs >>>>> like: Locking, Agent, ect... in order to reduce the resources sql >>>>> server use? >>>>> >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |