I use the (free) sqlserver2005 express database a lot. When you dont have the full version, you dont have a proper management tool either. The base management in VS2005 is very limited.

I could not even find a way to restore a databasebackup with it so I looked for an alternative and found some very usefull standard classes in the Microsoft.SqlServer.Management.Smo namespace.

Here you can download a small tool I created with these clases to restore a backupdatabasefile. Sourcecode also included.

http://www.overnight.nl/download/sql2005ExpressManagement.rar

screenshot: