I would forget about the GUI and open a query window in SSMS.
- Get the Logical file names and the PhysicalFileName, minus the path, from the BAK file
FROM DISK = 'YourPath\YourDB.bak';
and make a note of them. Let's say there are 2 file's:
YourDB - YourDB.mdf
YourDB_Log - YourDB_log.ldf
- Now restore from the BAK file moving the physical files to where you want them on your machine.
I would suggest you high light the code between the GO' and press F5 to run each bit separately.
(You will need to replace YourDB, YourPath etc with the correct values)
If there are any problems you will then know where they occurred.
RESTORE DATABASE YourDB
FROM DISK = N'YourPath\YourDB.bak'
-- RECOVER the DB and REPLACE it if it is already there
WITH RECOVERY, REPLACE --, CHECKSUM
--MOVE the logical files where you want them. There may be more files
,MOVE 'YourDB' TO 'WhereYourWantTheFile\YourDB.mdf'
,MOVE 'YourDB_log' TO 'WhereYourWantTheFile\YourDB_log.ldf';
-- Make sure the DB is multi user
ALTER DATABASE YourDB SET MULTI_USER;
-- Start by setting the owner of the DB to sa, you may want to change this later
ALTER AUTHORIZATION ON DATABASE::YourDB TO sa;
-- As this is a test DB, there is no point in letting the log grow
-- (You may want to change this later)
ALTER DATABASE YourDB SET RECOVERY SIMPLE;
-- Check the DB is okay
-- When moving a DB to a different machine, always update the stats.