Are you doing this through T-SQL or SQL Server Management Studio?

Try forcing database to single user mode first.

ALTER DATABASE MyDatabase SET SINGLE_USER WITH ROLLBACK AFTER 10

then after restore is successful

ALTER DATABASE MyDatabase SET MULTI_USER


I use SQL Server 2008 so this may need tweaking for 2005.