Thank You for the response.

Waiting for an update please!!!

If there is no option to purge ur data and move ur data to a dataware house and still wanting ur data to be lively,

Frist thing is u might want...

Hi,

Not necessarily, u need to re-build the log shipping right from scratch. AS per ur requiement, u need to bring the secondary database online for testing purpose.

Couple of options

Option...

Make sure the job u created is running under agent service account and provide execute as permission to the user if not restricted grant control as well and see.

Check if the sqllogin is orphaned.

There is a LSN mis-match. Find out the previously missed trn file and restore it.

Which version of SQL Server are you using? If its Sql 2008 and later, u can compress the log backup.

Are u using any 3rd party tools.

To sync both the databases,...

Got confused with the word "Other". Thought it was partial and uncontained!!!

When i run the original sp i m getting 616rows, but whem i m running the sp given by elutin, i m getting only 242 rows.

I will make sure to post in a right way next time. Apologies!!!

Currently its on sql server 2005.

Hi Elutin,

I m trying to execute ur code to test and i get this error.

Msg 243, Level 16, State 1, Procedure Select_QuotestoBind_TestSample, Line 9

Type DATE is not a defined system...

Hello Jeff,

Thank u so much for the replies. I would definetely consider ur suggestions and ask my developer to re-write whatever it takes to tune-up this code with ur suggesstions.

Thanks...

i have just shortened the startdate and enddate for just 10days with the actual execution plan. when i execute without selecting it it took be about 58secs to complete. When...