Re: General SQL Server 2005 transactional replication question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx>
Date: Tue, 20 Feb 2007 17:08:21 -0000

In that case I'd go for log shipping. Once the primary server is back up and
going, you could restore the database from the standby server or use
DataCompare to sync up the databases. Higher latency than replication but it
looks like you have little choice. SQL Server 2005 will offer mirroring
which you can use as a lower latency version of log shipping.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

.

References:
- Re: General SQL Server 2005 transactional replication question
  - From: Hilary Cotter
- Re: General SQL Server 2005 transactional replication question
  - From: Kev
- Re: General SQL Server 2005 transactional replication question
  - From: Hilary Cotter
- Re: General SQL Server 2005 transactional replication question
  - From: Kev

Prev by Date: Re: Replication Setup Issues
Next by Date: Re: SQL Server 2005 Trans Repl to Subscriber w/diff column names
Previous by thread: Re: General SQL Server 2005 transactional replication question
Next by thread: Replicated database restored to non replicated version
Index(es):
- Date
- Thread

Relevant Pages

RE: WSS install locked into MSDE DB - Can not install for SQL Serv
... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
(microsoft.public.sharepoint.windowsservices)
Re: How to Replicate an SQL Server 2000 Database
... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
(microsoft.public.sqlserver.replication)
Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
... I have had quite a number of clients that used a SAN for a database server and suffered significant performance problems because their underlying SAN infrastructure was a huge stripe across many drives. ... By application files I mean the binn folder which contains the sql server executable among other things. ...
(microsoft.public.sqlserver.setup)
Re: Where can I find my detached database
... The data file should be in your SQL Server Data folder. ... No chance SSMS to drop a database when you detach it. ...
(microsoft.public.sqlserver.server)
Re: FCB::RemoveAlternateStreams: Operating system error (null)
... Thanks for all your help Ekrem, even if your sugestion does not solve the ... in this edition of SQL Server the ... database so it's opened again and you get this error somehow. ...
(microsoft.public.sqlserver.setup)