Looking for best way to have SQL Server data security, replication as well as security maintenance
I joined a production environment recently, and I’m the key person here. We have 2 servers: one production server and a replication server. Data from the application goes to the production server every second and that is replicated to the replication server. We fetch the data from replication...
View Answer
| Jun 6 2008 7:21 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server security, SQL Server replication, Database security
Replication Logreader error. SQL Server 2000
Hi I am using SQL Server 2000 replication , I have separate publisher,distributor and subscriber servers running on SANs. I get below error and synchronization gets struck, becuase log reader could not read data from the publisher db. Could you give me a quick fix for this error....
Answer Question
| May 16 2008 2:29 PM GMT
| asked by
Krajdba
SQL Server replication, SQL Server 2000
What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?
What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?
View Answer
| Apr 30 2008 5:21 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server availability, SQL Server replication, Log Shipping
full-text replication SQL Server 2000
I'm having problems replicating a table that has full-text enabled using sql server 2000 sp4. When I start the distribution agent I get the following error:Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.proposals' because it is not full-text indexed.I have run sp_fulltext_database...
View Answer
| Apr 21 2008 6:14 PM GMT
| asked by
MarkT
Full-text databases, SQL Server 2000, SQL Server replication
Do you have to break the replication after you install a service pack in SQL Server 2005?
In SQL Server 2005 when you install a service pack - do you have to break the replication as you did in SQL Server 2000 - and then reestablish the replication?
View Answer
| Mar 11 2008 10:08 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server upgrade, SQL Server installation, SQL Server replication
Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005
Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005
View Answer
| Feb 25 2008 11:33 AM GMT
| asked by
LindaLawson
SQL Server replication, SQL Server 2005, SQL Server 2000
