Windows 2k3, SQL Server 2005, TDP 5.5.1.0

We had a situation recently where a coworker used the gui to recover a SQL 
Server database, with some unexpected results.
The database had a weekly full + hourly differential set, and he needed to 
restore it to an alternate name/location.  Selecting the diff version correctly 
selected the corresponding full, which he right clicked on to fill in the 
"restore into" and "relocate" options.
What seemed to happen when he clicked restore was that the full restored to the 
new db successfully, but the diff then tried to restore over the top of the 
existing production db.  Through some trial and error we discovered that the 
gui requires the "restore into" and "relocate" to be specified on both the full 
and the diff in order to work correctly.

Is this a planned design?  Because it has what I call a high "astonishment 
factor".  I would expect the gui to be smart enough to know that the full and 
diff are tied together and if I specify a relocate, it applies to both.  This 
obviously caused us some issues, as it attempted to write back over the top of 
a production database.

Steve Schaub
Systems Engineer, Windows
BlueCross BlueShield of Tennessee


-----------------------------------------------------
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm