mohammed moinudheen (1/19/2010)
There was once when I had to restore a database.Due to some reason, connections continued to persist on this database because of which I couldn't restore.
To overcome this, took the database offline and then performed the restore. 🙂
Also,you could have gone with the option of putting the database in Single_User mode-->end your own connection --> put the database back to multi_user mode. This is to ensure no connections are active and you can do your restore.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."