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.

At least not for me.

Its giving 6, 1 & 3 respectively.

Phil & Sean both are right but you can use something like this..

Insert into Table2 (col3)

Select col1 + ' ' + col2 from table1

May be we both are working on different data set.

Here is mine.

create table playground.sale (email varchar(255), quantityint);

insert into sale values ('email1', 1);

insert into sale values ('email1', 2);

insert into sale...

No, min or max would produce a different result that what he is expecting. Min will produce 1 and max will produce 3.