|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sql replication
Hi guys,
exist any replication method in SQL that the target db server avaialble for reading ? I need to replicate my database on another server but after i would make a query on this database target. The questions is for 2000 and 2005 SQL products. Thanks in advance. In 200x, you can use Replication or Log Shipping (setting read-only the
secondary), and in 2005/2008, also Database Mirroring. Take a look on BOL about this topics Show quoteHide quote "INPUTIO" <INPU***@IO.COM> wrote in message news:%23uo0Yri%23JHA.3320@TK2MSFTNGP04.phx.gbl... > Hi guys, > > exist any replication method in SQL that the target db server avaialble > for reading ? > > I need to replicate my database on another server but after i would make a > query on this database target. > > The questions is for 2000 and 2005 SQL products. > > Thanks in advance. > thanks you so much.
Show quoteHide quote "Carlos Sacristan" <nom***@nomail.com> ha scritto nel messaggio news:eXIDmVj%23JHA.4692@TK2MSFTNGP02.phx.gbl... > In 200x, you can use Replication or Log Shipping (setting read-only the > secondary), and in 2005/2008, also Database Mirroring. > > Take a look on BOL about this topics > > "INPUTIO" <INPU***@IO.COM> wrote in message > news:%23uo0Yri%23JHA.3320@TK2MSFTNGP04.phx.gbl... >> Hi guys, >> >> exist any replication method in SQL that the target db server avaialble >> for reading ? >> >> I need to replicate my database on another server but after i would make >> a query on this database target. >> >> The questions is for 2000 and 2005 SQL products. >> >> Thanks in advance. >> > Just want to add that if you want to query your 'replicated' data and want to
see that data up to date, log shipping ot database mirroring are not really viable. SQL Server native replication is probably what you need, especially when you don't need to query all the tables in the primary database. Linchi Show quoteHide quote "INPUTIO" wrote: > thanks you so much. > > "Carlos Sacristan" <nom***@nomail.com> ha scritto nel messaggio > news:eXIDmVj%23JHA.4692@TK2MSFTNGP02.phx.gbl... > > In 200x, you can use Replication or Log Shipping (setting read-only the > > secondary), and in 2005/2008, also Database Mirroring. > > > > Take a look on BOL about this topics > > > > "INPUTIO" <INPU***@IO.COM> wrote in message > > news:%23uo0Yri%23JHA.3320@TK2MSFTNGP04.phx.gbl... > >> Hi guys, > >> > >> exist any replication method in SQL that the target db server avaialble > >> for reading ? > >> > >> I need to replicate my database on another server but after i would make > >> a query on this database target. > >> > >> The questions is for 2000 and 2005 SQL products. > >> > >> Thanks in advance. > >> > > > > Hi Linchi,
so if i use a log shipping the replicated database is not avaialble for query a data ? Thanks. Show quoteHide quote "Linchi Shea" <LinchiS***@discussions.microsoft.com> ha scritto nel messaggio news:10882B88-47A4-4111-ADA2-1FA6D6E45ADE@microsoft.com... > Just want to add that if you want to query your 'replicated' data and want > to > see that data up to date, log shipping ot database mirroring are not > really > viable. SQL Server native replication is probably what you need, > especially > when you don't need to query all the tables in the primary database. > > Linchi > > "INPUTIO" wrote: > >> thanks you so much. >> >> "Carlos Sacristan" <nom***@nomail.com> ha scritto nel messaggio >> news:eXIDmVj%23JHA.4692@TK2MSFTNGP02.phx.gbl... >> > In 200x, you can use Replication or Log Shipping (setting read-only the >> > secondary), and in 2005/2008, also Database Mirroring. >> > >> > Take a look on BOL about this topics >> > >> > "INPUTIO" <INPU***@IO.COM> wrote in message >> > news:%23uo0Yri%23JHA.3320@TK2MSFTNGP04.phx.gbl... >> >> Hi guys, >> >> >> >> exist any replication method in SQL that the target db server >> >> avaialble >> >> for reading ? >> >> >> >> I need to replicate my database on another server but after i would >> >> make >> >> a query on this database target. >> >> >> >> The questions is for 2000 and 2005 SQL products. >> >> >> >> Thanks in advance. >> >> >> > >> >> Technically, you can query a database in the standby mode. But whenever
another log backup is applied all connections to the standby database must be terminated. Unless you backup your logs in very large intervals and your users are okay with their connections being terminated from time to time, the standby database is practically not usable. Linchi Show quoteHide quote "INPUTIO" wrote: > Hi Linchi, > > so if i use a log shipping the replicated database is not avaialble for > query a data ? > > Thanks. > > > "Linchi Shea" <LinchiS***@discussions.microsoft.com> ha scritto nel > messaggio news:10882B88-47A4-4111-ADA2-1FA6D6E45ADE@microsoft.com... > > Just want to add that if you want to query your 'replicated' data and want > > to > > see that data up to date, log shipping ot database mirroring are not > > really > > viable. SQL Server native replication is probably what you need, > > especially > > when you don't need to query all the tables in the primary database. > > > > Linchi > > > > "INPUTIO" wrote: > > > >> thanks you so much. > >> > >> "Carlos Sacristan" <nom***@nomail.com> ha scritto nel messaggio > >> news:eXIDmVj%23JHA.4692@TK2MSFTNGP02.phx.gbl... > >> > In 200x, you can use Replication or Log Shipping (setting read-only the > >> > secondary), and in 2005/2008, also Database Mirroring. > >> > > >> > Take a look on BOL about this topics > >> > > >> > "INPUTIO" <INPU***@IO.COM> wrote in message > >> > news:%23uo0Yri%23JHA.3320@TK2MSFTNGP04.phx.gbl... > >> >> Hi guys, > >> >> > >> >> exist any replication method in SQL that the target db server > >> >> avaialble > >> >> for reading ? > >> >> > >> >> I need to replicate my database on another server but after i would > >> >> make > >> >> a query on this database target. > >> >> > >> >> The questions is for 2000 and 2005 SQL products. > >> >> > >> >> Thanks in advance. > >> >> > >> > > >> > >> > >  
Other interesting topics
How to Enqueue Messages With Service Broker in a Timely Fashion
Create Database on the server Upgrading from SQL Express to SQL Enterprise Raid levels Maintenance did not delete old files sql server management studio to connect to database SQL Server Programming Books Rolling back bcp takes forever. Shouldn't. SQL-server Strange Behaviour ? Paging in sql server 2000 with select distinct |
|||||||||||||||||||||||
