re-attach that error file

Date,Source,Severity,Message

04/06/2013 15:07:45,spid18s,Unknown,waiter id=process3f66c70 mode=X requestType=convert

04/06/2013 15:07:45,spid18s,Unknown,waiter-list

04/06/2013 15:07:45,spid18s,Unknown,owner id=process3e99390 mode=S

04/06/2013 15:07:45,spid18s,Unknown,owner-list

04/06/2013 15:07:45,spid18s,Unknown,keylock hobtid=72057594039566336 dbid=18 objectname=LRModel.dbo.Constraints indexname=PK_Constraints id=lock515a2800 mode=U associatedObjectId=72057594039566336

04/06/2013 15:07:45,spid18s,Unknown,waiter id=process3e99390 mode=S requestType=wait

04/06/2013 15:07:45,spid18s,Unknown,waiter-list

04/06/2013 15:07:45,spid18s,Unknown,owner id=process3f66c70 mode=RangeX-X

04/06/2013 15:07:45,spid18s,Unknown,owner-list

04/06/2013...

Thank you for reply..

Server OS - win 2008 Ent.edition

Database - SQL 2008 standard edition with sp1.. not updated any culmative patch and sp3.

I have switch on tace falg 1222 on...

Thank you for reply..

1. Please confirm, 'step3', is it really required?

the below command for adding PAE in boot.ini file in windows 2008 enterprise edition 32 bit operating system..

BCDEDIT /SET...

yes.. it is working, thanks

what is the best intervel time configure at scheduling job for monitoring IO usages?

Thanks

ananda

At minimum I would recommend checking the setting for 'max degree of parallelism' and making sure that is set to no more than 8, which is the number of physical...

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 standard edition...

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