Content database migration in Sharepoint

Here I am showing you another easy way of taking share point backup/restore. I am using SQL server DB backup method.

First of all you have to find out which is the content database for your web application for that go to central administration Application Management and click on Content Databases
From the web application dropdown select your web application as shown below and find out the content databases
Then go to SQL server and find out the same content database from there
Take the DB backup as normal as we done in SQL server
Then take your backup and restore to your destination DB server. As shown below
Let Say I restore the Content DB under the name New_Content
Now open Central administration of your destination server
Go to Application management and click on Create or extend web application
Click on Create new Web application
Give Description and port as normal
Under the Database Server name ,give your Share point DB server name
Under Database Name give the name of the Database you just restored. In my case it is New_Content.
Click Ok then open your web application just created no with the url.You can see the share point site restored in the new destination server.