jeff.mason (7/16/2010)

---

There could be any number of points of concern. The Oracle tables might need a reindex. There could be issues with a network card. Really, you're...

Graeme100 (7/16/2010)

---

How much data are we talking about here ?

How big are the tables?

What is happening to the data before it is inserted ?

Need a bit more to play with...

Full recovery mode..

I tried taking a ful backup ,log and checked all the tables related to log shipping ..its all there

check the status of that database..SP_HELPDB

Thanks alot for the info Sankar

Is it not possible to find that from file created datetime??

MIrroring you can have automatic failover

transaction log is transferred from principal to mirror

http://en.wikipedia.org/wiki/Dining_philosophers_problem

SQL Server provides you HADR like

log shipping

Replication

Mirroring

Clustering

Choosing among this depends primary on your requirement

log shipping & Replication wont give u automatic failover..

Whats your requirement?

Automatic failover?

cost?

How much downtime acceptable?

second to Ashwani

Jason Shadonix (7/8/2010)

---

OK, what am I missing here? Why are you thinking you need to stop mirroring? Just take a log backup and truncate the log if it...

check the error log and try to put the exact error..

Hope ur agent is up and running...

Backward compatability is not there for SQL Server..

I dont know whether its possible using any third party applications..

Better u script out the things and run it in 2005