Actually one of my friend asked this question.

give full permissions to computer name on that UNP path folder

compare execution plans in DEV and PROD

and use the query hint for index.... that using in prod.

the same index will use in dev if you put as shown below....

Are you able see SQL SERVER SERVICES in SQL Server configuration manager?

if yes, started services?? check it .

I have transnational replication on PROD. suddenly we are getting consistency errors in replication because of update statement (not for delete and not for insert).

update command working as Delete/insert...

one final question: Does sequence matter? (our DB size is 500 GB that's why we need to take log backup too to get the latest data on PROD)

...

go this table "dbo.Postal_Original" and drop FK_Postal_CityTownship constrinat

then try with delete command, it works

if still repeats , you have to keep on drop the constraint or delete...

Thanks for response.

My set up steps: I took full backup then created publisher then took differential and t-log backup

next Initialize database backup..

My mistake is , i took full back up...

you can run profiler using filters(by db_id, login_Name) , so that it will reduce the burden on the server , anyhow its not a good idea.

select text from sys.dm_exec_query_stats

CROSS...

Thanks for your reply. I think we can move/transfer data by Using switch command. my problem is .. delete complete data in one file group. If i...

total table space means data size plus index size?