I needed an exact copy of a database under another name. I choose for cloning SQL Database via Backup-Restore, using SQL Mgt Studio 2008. Firstly, when restoring the database; I received an error.
SqlError: The backup set holds a backup of a database other than the existing 'Pro_SSRS' database. (Microsoft.SqlServer.Smo)
Then I found out I had to choose for the option "Overwrite the existing database" Seen at various sites, for example here: http://www.nikhedonia.com/notebook/entry/solving-the-sql-server-restoring-database-error/
Now next to my database name I see "(restoring...)" and it's already for a half an hour. I can't even view the properties of the database, most options say "unavailable".
Can someone explain? Or is this normal?(the database is like 20MB..) Thanks in advance!