use MERGE

Try profiler

ssis version??

post the code...ideally it should not

select top 20

Servername, count(*)

from tablename

group by servername order by 2

Hope this answers your problem

any pointers????

I was more interested in knowing error of the problem rather recovering

I tried restoring to the same primary server and it succeeded. So story so far is...back up of primary can be restored on primary but not on secondary. here are...

Use <dbanme>

go

SELECT case

when sysfilegroups.groupname is NULL then 'LOG'

else...

manually copied to secondary server, disk verified. Error below:

Msg 9004, Level 16, State 6, Line 1

An error occurred while processing the log for database '####'. If possible, restore from...

I am not relying on the copied location instead now I am giving path directly to backup file with unc...e.g\\primaryserver\backup\abc.trn

I dosent work even after specifying restore file path same as backup location.

means I am picking same backup file