You might want to consider looking at the RESTORE command : http://msdn2.microsoft.com/en-us/library/ms186858.aspx

You could wrap that in stored procedure logic if you wished.

Simon