Database migration from SQL 2008 to SQL 2012 for SharePoint 2010

Hi All,

We recently updated the database for our SharePoint 2010 application as Microsoft has stopped support for SQL 2008
Steps migratiing database are as follows :

1. Install SharePoint SP1(Service Pack 1) on Application server and reboot. Test the application and make sure it is working fine 
2. Install SharePoint SP1(Service Pack 1) on WFE server and reboot. Test the application and make sure it is working fine.
   Note : Service Pack installation is mandatory 
3. Once your application is working fine, you need to stop following services on application server and WFE 
4. *SharePoint 2010 Administration
5. *SharePoint 2010 Timer
6. *SharePoint 2010 Tracing
7. *SharePoint 2010 User Code Host
8. *SharePoint 2010 VSS Writer
9. *SharePoint Foundation Search V4
10. *SharePoint Server Search 14
11. *World Wide Web Publishing Service
12. *SharePoint Server Search 14
13. *SharePoint Foundation Search V4
14. *SharePoint Server Search 14
15. *Web Analytics Service(in services.msc)
16. * IIS
18. Ensure no connection exists on the databases (Run command sp_who2 on SQL instance "Servername\Instance name" and confirm.Kill the connections if needed.
19. Backup content database & custom database
    Note : Make sure there is enough space to take back up and other drives.
20. Detach all user databases using and secure respective .mdf & .ldf files.Ensure all the user databases are detached before proceeding further.
21. Start uninstall process of SQL 2008 R2. Select your database instance while uninstalling.
22. Once uninstallation completed, re-boot the machine
23. Start installing SQL 2012
24. Ensure data drives and backup drives are configured to drives which have ample of space to cope up with database size requirements.
25. Ensure Instance name 
26. Make sure to add your Admin users and sa account as Administrators
27. Attach all the database which were detached in earlier steps 
28. Change database property to SQL 2012
    Will update any details/scripts related to this shortly
29. Start all the stopped services and start IIS
30. Test you application 

Tada ! Its should work :) 

You can also user performance monitor tool to make sure the data hasn't changed before and after database migration.

I am pretty much sure that this strategy can work on any version of SharePoint but I would advice you to carry this activities on Development server and upon successful execution can be carried on Production servers