I got it.. according to SQL output 16 Logical CPU...

Pl. correct me if am wrong direction.

For the performance basis for SQL SERVER parallel processing should be equal number as...

Thanks for your reply...

server have 2 Intel Quad Core CPU 3.6 GHz, so 4 core multi processors and 2 scokets..

How it enable hyperhtread Ratio and Logical CPU both are same...

All the database in FULL recovery mode.. and configured FULL backup including system database..

Tlog configured for all the database exculding system database.. Tlog failed y'day after noon after that I...

It was working fine last one year, Y'day Tlog backup failed after 1:30 PM and received mail alert for Tlog backup failed due to above error which is posted in...

As per your advise me, No error history available in M.Plan history.

http://support.microsoft.com/kb/919224,

Error will be resolved after installing latest SP in SQL 2K8.

Version - SQL Server 2008...

sorry for mention above errores

I have tested failed backup files, and encounterd errors were from damaged backup file set on 02-03-2013

Successfully restored last day at 01-03-2012 good backup set and...

Job disabled stage run manually, it was run with as below error...

Executed as user: servername\ExpSQLAgtSvc. 16 percent processed. [SQLSTATE 01000] (Message 3211) 33 percent processed. [SQLSTATE 01000] (Message 3211) 49...

ok, Thanks...the same version can possible to configure for log shipping...not concern with 32 or 64 bits and 2008 R2

I have doubt, destination server - SQL 2008 32 bit enterprise edition, it is not higher then source server.

source server - SQL 2008 R2 64 bit enterprise edition.

Pl. confirm.

thanks

removed existing LS before I got reply from you

Before I have removed existing LS configuration at primary server after verify the LSN numbers...

thanks

Yes, Mr. Perry you are right, TransactionLog file was deleted at secondary server...The last restored Tlog on 29-Dec-2012 at 4 AM, LS tried to apply next LSN but it was...

Pl. Let me know, In export wizard FK, PK and constraints does not come to destinaton database..Is it correct?

deleted all records BETWEEN '2012-12-14 00:00:00.000' AND '2012-12-15 00:00:00.000', specifytime period...Not for whole table data.

After exporting data into all tables then we can not recreate FK relationship to the table.

Instead drop and recreate FKs, I did disable all the constraints then export data to...

Thanks Mr.opc.three , It was working fine...with Merge delete statement