one more question , Why developers have access to production?

Use Generate scripts , scroll and select only the necessary SP's.

By the way why are the developing it on a prod server , don't you have dev server fro this...

'\\test1\I$\Logbackup', does I$ has permission for service account or you have given the path worngly?

is it something like this '\\test1\Logbackup'

use msdb

select * from log_shipping_monitor_error_detail

anything on this during that period on both the servers.

Eswin (10/28/2013)

---

We have a production 10TB database.

We need a copy of the production database for development team and the dev database should be updated with the change in prod...

Log shipping status report is showing not in sync or out of threshold for "X" minutes?

Can you give the exact error that is there on the job failure restores or...

phani404 (10/21/2013)

---

Violation of PRIMARY KEY constraint 'PK_table_access_id'. Cannot insert duplicate key in object 'dbo.table_access_id'. The duplicate key value is (268435492, 1). (Source: MSSQLServer, Error number: 2627)

Get help: http://help/2627

Can any one...

what is the status on primary and secondary job any error or findings?

free_mascot (10/30/2013)

---

Just to clarify further...

Only if you didn't apply any Tlog backup your diff backup will work. Differential backup can't be apply on secondary server if subsequent tlog backups have...

have you used sp_executesql for executing dynamic queries?

can you build the full text in the variable and then try exec

Have you tried "View history" through "Job Activity Monitor"?

I dont think so, it is just for monitoring backup, copy, restore job at a common location else you have to find it primary and secondary for their respective status.

try scripting the jobs with various options , it will use some System procedures to create, schedule , enable etc.

if you can manage well these you can manage it through...

Can't you avoid the sub queries used these many times?

try inserting the subquery data to temp table and update and see how query performs.

as suggested above plan is best to...