Thank you everyone, I was able to take care of my problem,the only thing is when I run sql job for replication:here is the code:runs under Replication snapshot:

-Publisher [DB1] -PublisherDB...

hello,

I restored database to a new name and want to delete bads one,get error messa:

Cannot drop the database because it is being used for replication,how can I remove it?

error message,I have differential and full backup

I have differential from yesterday

ldf,mdf,ndf

I have a Redgate backup,[298] SQLServer Error: 4060, Cannot open database requested in login 'DatabaseName'. Login fails. [SQLSTATE 42000]

Is there way maybe, to call sql job from another server and that job will have restore syntax?

Thank you

Thank you

Yes,this is just for tables,what about any changes on database?

No, I have like 20 different databases, is there way to copy everything what we have on one server to another server?

Thank you

When I tried to create clustered index as you said and assign to read only file group,I get an error message:that can't save because this file group is readonly

Thank you,How you move the table into a separate filegroup?

Thank you,but how would you add this to table?

Can you give me an example please

sorry this an error:

it should be Can't generate SSPI Content