Hi Gail,

Thank you for the replied.How can we solve the issue.Could you please provide the solution.

Hi Gail,

Use DBCC FREEPROCCACHE to clear the plan cache carefully.But i'm getting dialy same information from error log.Is it critical

both the local servers able to connect windows login only.but when i am trying to connect(windows login only) another sql server(other server).At the same time i am facing error

Cannot...

no asish,

Sorry cant understand, your server is sql 2005(as per screenshot) or 2008R2.

both servers are sql server 2005 sp4 only.

If you saying you both server are on same version of...

Thank you for replied Ashish

I have configured logshipping primary server is local and secondary server is different location.i am able to login in sql server 2008 R2 both servers...

yes my login is active.

two servers like source server and destination server are i am not able to login but i am able to login SA login .the...

GAIL i am waiting for your reply

please

I already disabled the maintainance plan log backup.

Thank you for great answer Gail.

Bye

Thank you Gail.I have disabled the Transaction backup job.Let me tried logshipping agian.

So Gail,

Due to the Transaction log backups it will effect the log shipping.can i disable the normal log backup.

Yes gail.

Logshipping backup job is 25 min

Normal log backup is 1 hour.

but three times restore jobs had been failed.Like out of synochronozation.

how can i solve the issue.

Hi Gail,

No,that is Normal log backup.i am taking all backups through Maintainance plan.

sorry guys i am out of town.Thank you guys

I have configured logshipping both live databases succesfully.but next day restore jobs are failed.

backup job is 25 min

copy job...

Thank you for the answer.

is there any solution.

thank you for the answer ankur_libra