Steps for Backup and Restore of SQL database from SQL server 2008 / 2008 R2 to 2012.

Steps of Performing Backup activity in SQL server.

1. Login to the Database server through SSMS.
2. Right Click the Database -> Tasks -> Backup (Refer Figure 1)
3. Choose the path where the backup file need to place. (Refer Figure 2)
4. Choose the Full in Backup Type and Select Copy-Only Backup in Production Environment. (Refer Figure 2)
Note: Move the backup file of SQL database to any file share or the destination server HDD.

Steps of Performing Restore activity in SQL server 2012.

1. Login to the Database server through SSMS of 2012.
2. Right Click the databases (Next to the server name) -> Select Restore Database.
3. Select the Device and provide the backup file as a input to restore database window.
4. Give a unique Database name to identify. In this scenario I gave “WSS_Content_5002_MigratedfromSP2010”
5. Once Database restored successfully, close the SSMS.