transactional or snapshot. why you are using C drive?

use unc path which should a shared directory.

for your issue check whether directory is shared or not. check in event viewer it...

can you provide instructions how did you configure TR or you can script out and share with us.

I am thinking you did not configure properly on subscriber server did you...

thanks Alan for your response. I have completed all the test runs with different block size, results see to be good (I don't know ;-))

ex for 8k block tested...

I quickly ran wait stats on the server in question. the two session that are in blocking state have following locks

PREEMPTIVE_OS_GETPROCADDRESS blocking

LCK_M_S blocked

I believe blocking session is holding lock...

I am going to give a try

Can you provide build numbers of both servers.

Do you have any other server UAT or test where you can restore?

I have same errors recently, storage team didn't attach storage properly which caused the problem(Don't know why they are playing with storage in PROD using ISICI).

after the server reboot...

both the cases difference in estimated vs actual is high try to updates stats and see it helps in QA only

is it a native backup or using a third party tool. what is the extension of the backup file.

can you do restore headeronly and filelistonly on the server where...

stop distribution agent b/w publisher and subscriber

replication information stored in distribution database

select * from MSrepl_commands

where command_id = 1

sp_browsereplcmds

you can replicate schema changes to secondary's. please review msdn

https://technet.microsoft.com/en-us/library/ms147331(v=sql.105).aspx

is fk columns indexed properly?

looks like objkeys table has two columns parented, okeyname(guess if not correct me) if it is true why you need to use char columns in where...

ok thanks I got to two levels upto get objects that I need to alter, replace parameter . issue is with making alter statements instead of create.

if we cannot...

sorry about that edited and provided the code I am working