Sharepoint - How to Rename Content Database Name of Live Sharepoint Site

Sometimes it is requirement to change the name of Content database after setting complete Sharepoint site. If you've such requirement then following is a solution -

1. Open SQL Server Management Studio.
2. Go to Content Database node in Database explorer
3. Take the database Offline
4. Detach the database from Sharepoint using Sharepoint Central Administration.
5. Back up the database using SQL Server Management Studio
6. Restore the database using desired name
7. Re-attach the database to Sharepoint using Sharepoint Central Administration.

Complete.