Yes it may slow down the performance, as it uses parallel sessions to execute the DBCC.

So execute it after peak hours. It took 5 mins in my system for the...

Did you try DBCC and check for more information on fragments?

Thank you The_SQL_DBA for your elaborate details on the subject. Let me go through this and get back to you.

Thanks again for your time!

Below are the error message from the log, is this information enough to troubleshoot?

Backup can not be performed on database 'SCom'. This sub task is ignored.

End of maintenance plan 'DB...

No Clue. :ermm:

Can I know from the system? there is no much information the logs to troubleshoot.

There is no space/permission/deadlock issue during the backup time.

Verified the user/service/account which is running the job/agent has full permissions.

I have deleted and created a new plan and could see the old backup files are getting deleted, but...

SQL Guru's is this so challenging :blink:

Other options like user login failed to work of what reasons could not get the error output for analysis, but this works.

\full path\OSQL.EXE /E /d "Dev_db" /i "C:\SQL\dummyexport.sql" /o "C:\SQL\DE.csv"

Experts...

How do you specify the server name when it is configured as local?

It gives me cannot open login fails

Are you doing a transaction backup?

If yes, then it would decrease.

If its a gradual increase its the way it is, if not then your transactions are doing more.

Hope this...