When I backup my SQL-Server DB to flash disk from server named server1, The operation was completed %100 successfully.But When I had tried to restore IT FROM FLASH DISKE to an other server called server2 the SQL server 2005 desktop Management studio refused the order and responded "The database is used by an other user while in fact there is no other users on the server except me (the adminstrator).When I had restored the same DB to the same server(server1) , the restore order had been completed successfully.
please explain to me why? and how can I restore my backup DBs to another servers ?