Aww crap! I didn't mean to mark my response as the Answer! Sue and Richard gave the direct answer to the question I presented. Sorry guys 🙂

Thanks for the assist guys and sorry for the lengthy delay in responding: I was out of town for a couple of weeks on vacation! 🙂

So it looks like NetForum...

No need to reply, as the proof is in the pudding! The updated process works like a charm (until it doesn't).

Thanks again

Spoke too soon!

Last night, I encountered another case of "Exclusive access could not be obtained because the database is un use. [SQLSTATE 42000] (Error 3101).

I read up more on the...

• This reply was modified 5 years ago by  kranitz.

I wanted to let all know that the suggested changes worked perfectly. I have had no issues with the restore since implementing. MANY thanks to Michael and Chris for their...

OK - Thanks for the clarification. That makes sense to me.

I'll check in the AM to see how it goes. Thank you, gentlemen!

OK - incorporating both Chris and Michael's suggested edits. How does this look:

ALTER DATABASE nfache1nrt
SET RESTRICTED_USER WITH
ROLLBACK IMMEDIATE
go

RESTORE DATABASE nfache1nrt
FROM DISK = 'C:\Temp_NRT\nfache1NRT.BAK'
WITH MOVE 'Sneferu_Data' TO 'C:\Program...

Super helpful - I'm going to adjust that and try it out tonight. As you can see, I shouldn't be allowed to manage other folks' SQL environments lol 😉

This might...