Recent IT Questions

1 - 6 of 6
<<PREVIOUS 1 NEXT>>

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


1 - 6 of 6
<<PREVIOUS 1 NEXT>>