Check this link.

http://www.sqlservercentral.com/Forums/Topic326235-5-1.aspx

Brent Ozar have this very useful and perhaps the best material online for virtualizaing SQL Server.

http://www.brentozar.com/sql/virtualization-best-practices/

Could you please post the table structure and attach a sample file?

You can initialize from backup. That is the best way to do replication for bigger databases because it eliminates all bcp generation hence locking/ blocking.

I agree with Robert Davis, once mirroring is suspended, it is not started automatically, you have to issue "ALTER DATABASE DBName SET PARTNER RESUME", then only the mirroring will start...

My mistake. Missed that part.

Use Batch insert/update/ delete instead of doing it in one big batch.

Increase default value of the ReadBatchSize in Log reader agent & CommitBatchSize in Distribution Agent.

If the table is out of sync because of load, this may help.

I think that any how some rows form Subscriber were deleted/modified. Are there any trigger defined on subscriber?

You can change the distribution Agent property for "Continue on Data Consistency...

Use this sql.

SELECT

B.name AS TableName

, C.name AS IndexName

, C.fill_factor AS IndexFillFactor

, D.rows AS RowsCount

, A.avg_fragmentation_in_percent

, A.page_count

FROM sys.dm_db_index_physical_stats(DB_ID(),NULL,NULL,NULL,NULL) A

INNER JOIN sys.objects B

ON A.object_id = B.object_id

INNER JOIN sys.indexes...

Open office works best for me..the only exception is when I am dealing with the production issue. In that case I wish that nobody should disturb me.

Also increase default value of the ReadBatchSize in Log reader agent & CommitBatchSize in Distribution Agent.

Look for the line breaks in the export. That will cause the difference in count.

You have to use 3 commands in sequence

1) exec sp_repldone @xactid = NULL, @xact_seqno = NULL, @numtrans = 0, @time = 0, @reset = 1

2) Truncate the Transaction log

3)sp_replflush

and I used second one.. which was more specific.