Grant Fritchey (4/5/2011)
Can you try using restricted user instead of single user? I've seen applications that constantly refresh their connection so they can squeek in before you start the restore.
If this doesn't work, then you have some process refreshing its connection and is using a privileged account.
I prefer taking the database offline myself - this insures that nobody can access that database and allows the restore to proceed with no problems.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs