• Take a backup of the database on 2008R2, example shown below:

    USE Master

    GO

    BACKUP DATABASE [SQLTraining]

    TO DISK = N'D:\SQLTraining_FullBackup.bak' WITH NOFORMAT, NOINIT,

    NAME = N'SQLTraining-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

    GO

    Restore the same on 2012 box

    USE master

    GO

    RESTORE DATABASE [SQLTraining2012] FILE = N'SQLTraining'

    FROM DISK = N'D:\SQLTraining_FullBackup.bak'

    WITH FILE = 1,

    MOVE N'SQLTraining'

    TO N'D:\SQLTraining2012.mdf',

    MOVE N'SQLTraining_log' TO N'D:\SQLTraining2012.LDF',

    NOUNLOAD, STATS = 10

    GO

    This works like charm 🙂

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter