Hi,

I tried both ways. Even RDP to the machine where the Report serverices are running also not working

Thank you.

Yes. I didn't see any size difference in backup file.

Will there any performance impact by reducing the mdf file size?

Thank you.

I copied your syntax and restore started working fine.

I restarted the agent and run the job. But it is giving the same error

We are using only Windows logins. Only apps are using Sql Logins.

I can able to...

Yes. My account has read/write/execute permissions on the backup directory!

Do you mean

The alter database to restricted mode is failing because some other sysadmin connection is being used that time.

This is exactly running in step1

BEGIN

DECLARE @kill varchar(8000) = '';

SELECT @kill...

Do you mean

The alter database to restricted mode is failing because some other sysadmin connection is being used that time.

This is exactly running in step1

BEGIN

DECLARE @kill varchar(8000) = '';

SELECT @kill...

Now I can able to connect to the database.

Here is the my main issue.

We have a sql job which has several steps.

In 1 step, we are killing the existing...

You mean service account. Both are using same service account.

Thanks for all your suport.

Server restart resolved the issue

Yes, the service account has read\write & modify permissions on the shared path. We are using SQL Agent & Service account both are same.

I am not able to take the successful backup manually.

Also it is generating dump files with access vilations whenever the backup is running either manually or scheduled

Thank you.

I am not asking about renaming the linked server name renaming the catalog

Why it is not good option?