I have two server farms, Server farm 1 and Server farm 2. Server farm 2 runs SharePoint 2010 Enterprise with SQL Server 2008 R2 Enterprise and Server 1 runs SharePoint 2010 Enterprise with SQL Server 2008 R2 - Express with Advanced Services. I created a backup of my content database of web application running on farm 1 and restored it to sql on server farm 2. I then created a new web application on farm 2 and attached my content db.
Now after I added content db to my new application on farm 2, it shows no site collection and when I try to visit the url I get page doesn't exist error message.
Am I doing anything wrong?