Home Forums SQL Server 2005 Backups Restoring from one instance to another... RE: Restoring from one instance to another...

  • I keep getting...

    Msg 102, Level 15, State 1, Line 6

    Incorrect syntax near 'MOVE'.

    Here's my actual SQL

    RESTORE DATABASE HCN_PROD2

    FROM DISK ='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\197.bak'

    WITH REPLACE

    MOVE '197' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Data\HCN_PROD2.mdf',

    MOVE '197_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Data\HCN_PROD2_log.ldf',

    MOVE '197_Audit' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Data\HCN_PROD2AUDIT.ndf',

    STATS=5

    What might I be missing?