• 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'+ (select CONVERT(VARCHAR(8), getdate(), 112))+'.bak'

    WITH REPLACE,

    MOVE 'DEV-Database_Data' TO 'C:\MSSQL\DATA\Dev_Database_Test.mdf',

    MOVE 'DEV-Database_1_Data' TO 'C:\MSSQL\DATA\Dev_Database_Test_1.ndf',

    MOVE 'DEV-Database_Log' TO 'C:\MSSQL\DATA\Dev_Database_Test.ldf'

    ALTER DATABASE Dev_Database_Test SET ONLINE

    GO

    ALTER DATABASE Dev_Database_Test SET MULTI_USER

    GO