If you are after absolutely no down time, the your best off implementing Cluster Server. Replication and Log shipping are not meant to be for Disaster Recovery although you can...

That works well. Thanks.

I will ask the Oracle DBA however, this is the entry in the TNSNames file.

I can connect to it via Oracle EM, so the entry is valid.

ORS5330 -Prod =

  (DESCRIPTION...

Ok.

How do I find out the SQL*Net alias for the Oracle database?

The Oracle Server name is ORS5330 and the Database Name is FPS.

How do I incorporate that in the SQL*Net?

This thread should be in the Replication Forum!

However, at what stage does the replication fail? Does it fail on the initial snapshot or when transactions are getting replicated?

Also, is your...

You will have to enable AWE. See BOL for Info. Then you will have to manually allocate RAM to SQL Server via it's SQL Server Properties.

So whats the error?

Dick,

I have had to do this myself and the approach I took was to Script the entire Replication Process. Disable it and then restore the Databases to the new server...

Cayley,

You have stated that "The error is “can’t insert row into table B  - record not found in related table A”."

Are you sure that the record that Replication...

My suggestion would be to run Profiler to see what sequence of events is taking place at the time the DBCC CHECKDB is running along side the ETL.

My guess is...

Remove the ( READPAST, ROWLOCK) Hints in the FROM Clause.

One way to do this is to DETACH the Database and ATTACH it again with only the mdf file that way it will create a new ldf with a size...

Are you able to start SQL Server in single user mode? If so you can then maybe change the path to the error log file path.

You should be able to just Synchronize A & B. That way any modifications that have happened on A will be propogated to B.

If help is all you have when you rigt click then you obviously do not have permissions to drop subscriptions.