ASPNETDB.mdf cannot be overwritten. It is being used by database ‘…’

You might encounter this error when you are trying to restore a database. For other problems you may face during the procedure see my post. Assuming you have other issues fixed, let's keep going with this one. Open SSMS. Right-click

Read More ASPNETDB.mdf cannot be overwritten. It is being used by database ‘…’

The backup set holds a backup of a database other than the existing ‘…’ database.

So your are trying to restore a database from the backup of another database with another name and you encounter this error. Here is how you can overcome it. Open SSMS. Right-click on the database you want to restore. Follow

Read More The backup set holds a backup of a database other than the existing ‘…’ database.

Database ‘…’ is already open and can only have one user at a time

If your database is stuck in single-user mode, connect to 'master' database and right-click on your stuck database. Click Properties->Options, scroll to the bottom and change “Restrict Access” value to “MULTI_USER”. How to connect to master db? Easy. First, close

Read More Database ‘…’ is already open and can only have one user at a time