RESTORE DATABASE [dev]
FROM DISK = N'L:\Backup\Full\prd\prd_backup_201301230000.bak'
WITH FILE = 1,
MOVE N'prd_data' TO N'G:\MSSQL\Data\dev_data.mdf',
MOVE N'prd_log' TO N'G:\MSSQL\Data\dev_Log.ldf',
NOUNLOAD, STATS = 10
GO
ALTER DATABASE TestDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE [TestDB] FROM DISK = N'C:\Temp\ProdDB_backup_2013_01_01_203001_8747913.bak' WITH FILE = 1,
MOVE N'ProdDB' TO N'M:\Sql_Data\TestDB1.mdf',
MOVE N'ProdDB_log' TO N'L:\Sql_TLogs\TestDB1_1.ldf',
NOUNLOAD, REPLACE, STATS = 10
ALTER DATABASE [TestDB] MODIFY FILE (NAME=N'ProdDB', NEWNAME=N'TestDB')
ALTER DATABASE [TestDB] MODIFY FILE (NAME=N'ProdDB_log', NEWNAME=N'TestDB_log')
ALTER DATABASE TestDB SET MULTI_USER;
I'm not replacing anything so why would I need replacebut you said in your list of steps:
I opened a new DB called RestoreDB.To me, that sounds like you created the DB you are trying to restore to first.
I clicked on Restore.