The SQL Server Single User Mode only permits one connection to a database at a time. Great for testing, but not for deployment. Here is how you can get it out of this state.
When you backup a database and then later try to restore it, you might get a message that the database is in a restoring state. Here is how you can fix this.