Thanks you for the help grasshopper. I had the same logical files names for both databases.

The names no longer protect the innocent, but who really cares...Thanks

DEV-Dysel_Datac:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DEV-Dysel_Data.mdfD PRIMARY

DEV-Dysel_1_Datac:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DEV-Dysel_1_Data.ndfD Data Filegroup 1

DEV-Dysel_Logc:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DEV-Dysel_Log.ldfL NULL

select name, physical_name from Dev_Dysel_Copy.sys.database_files =...

Even when I'm setting the database offline, WITH REPLACE & MOVE... I'm getting the same error...

Here's my syntax:

USE [master]

ALTER DATABASE Dev_Database_Test

SET OFFLINE WITH ROLLBACK IMMEDIATE

GO

RESTORE DATABASE Dev_Database_Test

FROM DISK='C:\MSSQL\Backup\DEV-database'+...

Here’s what works!

 IF         (SELECT Count(*)

                 FROM          TC_0002.EMPL

                 WHERE Last_Name = @Last_Name) > 1

Thanks for the help.