• ????

    To restore a database, right click the databases folder (object explorer), select Restore database. Select the Device radio button. Locate the backup, select which backupset in the file you want to restore (if there's more than one), Type in a database name (the database name dropdown can be typed into). Go to the second tab, specify the new locations for files if applicable.

    Click OK.

    That's it, no creating dummy databases, no creating dummy files, they're not needed and doing so can lead to an incorrect perception as to what's happening and what's required.

    Or, if you prefer,

    RESTORE DATABASE <new database name> FROM DISK = <location of backup>

    WITH

    MOVE <logical name of the mdf file> TO <new location and file name for the mdf>,

    MOVE <logical name of an ndf file> TO <new location and file name for the ndf>,

    .. repeat for other ndf files ...

    MOVE <logical name of the log file> TO <new location for the log file>

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass