Venu,

I think it is time to hit the BOL. Everyone has tried to help you but you are not taking any initiative to look up anything on Books Online or...

If your Tables in Publisher DB has PK, then you can set up the Transactional replication. Usually the latency is around 2 to 3 seconds. Does that answer your question?

Better to take precaution and ask than give him an advice that could potentially be trouble to him... :hehe:

I made sure that I had the best Network guy working on it this time... 🙂

george sibbald (5/14/2009)

sounds perfect for logshipping then.

ship to the same server to a database of...

I was just about to post the update.... And Gsquared beat me to it.... 🙂

Yes, we fixed it. We had to upgrade the Frameware and redo the Network teaming. That...

Mine is a Dell XPS M1530

Core2 Duo, 256 MB NVIDIA, 4 GB, 15.4" Wide Screen WXGA (1280 x 800) display with TrueLife.

Not Bad. Company gave it to me.

BCP, Back up.

This is still alive? I thought this thread was dead and buried.

Take a look at Database snapshots.

Transactional Replication is the best way but since you dont have PK created for all tables, it is out of the question. Snapshots can lock...

It could be because the connection once opened is not closed properly? Something to look at. You can get a rough idea by doing a perfmon counter on Login vs...

Does it show any error in the logs?

Service account is needed if your Sql Server has to access resources outside the box. Like a share to take back up or replication ect.

Service account should not be an...

Service account should be set up as a separate login. I think SQL Server creates that user and sets up the rights if you use the SQL Configuration manager to...

Editing would be a very bad idea.

http://www.replicationanswers.com/Transactional.asp

Here it gives some details about how to use that view and some stored procs that can be used.