Restore the database files to a different location. In a RESTORE statement, use a WITH MOVE clause to move each file. In SQL Server Management Studio, change the file locations in the Restore the database files as grid of the Restore Database Options dialog box.