Backup - Restore Content Database to another farm SharePoint 2010 Power Shell

We need few steps to do it:

1. Backup data from source.

For this we need check which database we use for this web application

and backup the database:

From the SQL Server that your SharePoint farm users and where the instance of DB resides, backup the database.

2.Restore the database to the destination :

Take the backup file to the target SharePoint Farm's SQL Server (where we want to restore it to) and restore the database

Now we have a new content database, but we need to connect it to our SP.

Therefore we open SP Powershell :

3. Dismount old database:

Dismount-SPContentDatabase "Contoso_PortalContent_Old"

4. Mount new :

Mount-SPContentDatabase " Contoso_PortalContent_New" -DatabaseServer "contoso_db" -WebApplication http://contoso.com