Well, I am just going to leave it as is. I was curious if it would improve anything.

I hope someone has a recommendation for this MS oversight.

Would love to be able to specify in the SQL Server configuration where to save the files,

but in the meantime the...

Perfect.

That will work exactly like I need it to. None of the users are owners of anything, all I allow them to do is run Select statements on views...

Thanks for the links. They are very helpful and useful.

I want to keep db1 as is, and overwrite db2. db2 is my sandbox playground, where I can do what I want to a copy of the real data,...

I have a full backup of an existing database named db1, which I am trying to restore in an existing database named db2, on the same SQL server instance.

This is...