Error when restore sql database from .bak file

Answer 1

When you configure the restore, make sure you aren't using data/log files that are in use by a database that is currently running (probably the database you're restoring on top of).

It makes the data directory a mess, but I give my data/log files a Rev. number when I restore databases so I don't run into that issue.

Answer 2

Are you sure SilosFollow_log is a database backup and not a transaction log backup?

In order to restore transaction log backups you must first have restored a full database backup and any differential backups. Then you can restore the transaction log backups in turn.

Answer 3

Any Idea how did you resolve the issue, I had a same issue and I am still waiting for it resolution.

Could anyone please answer me how can i get rid of this error?

Thanks