I'm practicing a SharePoint 2010 to 2013 migration and having trouble restoring a database. After backing up a database on a SP2010/SQL 2008 server, I'm trying to restore it to a database I've freshly created on my SP2013/SQL 2012 server.
Though the UI, I've taken the destination database offline. I select the .bak
file, select my destination database, and attempt the restoration. I get an error: Exclusive access could not be obtained because the database is in use.
Why is this happening? I've taken the database offline, I don't see how it could possibly be in use.
In the restoration window, I've tried going to Options and selecting Overwrite the existing database (WITH REPLACE)
as well as Close existing connections to destination database
.
Still the same error message. How do I get past this error?