As long as the owner for the both the databases is same, you only need db_reader in the database where synonyms are created alongwith just 'public' role for the user...

So you are saying that 300gb that is allocated upfront is not getting used at all?

Thanks!!

Are you able to connect to the UNC path using the managed service account from your local machine?

yep...but just thought that is more simple 🙂

Hi

Please check the compatible level of the database as in case of a backup restore, compatible level is not automatically upgraded to the current levels.

Thanks

Salil

Hi

I think this would be a better bet

select * from Form where FromID not in(3,4)

Thanks

Salil

Are you getting any other error apart from the one mentioned above