For the purpose of checking the integrity of backup, I configured a SharePoint 2010 development environment on a Windows 7 machine. I had taken content database backup of my production farm using the SQL Server Management Studio backup option.
These are the steps I followed on my Windows 7 machine -
I copied the .bak file to my development environment.
Restored the copied database backup using SQL Server Management Studio "Restore" option by restoring it into a new database.
Created a new Web Application using Central Administration.
Removed the current database of the newly created Web Application by using Central Administration -> Application Management -> Manage Content Databases
Verified the Content Database using this command -
Test-SPContentDatabase -Name restorethisdb -WebApplication http://ip:port
Added the restored database to my new Web Application using command -
stsadm .exe-o addcontentdb -url http://ip:port -databasename restorethisdb
Now, these are the problems and doubts that I have -
I cannot access the restored Web Application on my development environment if I do not know the url of the web application on my production environment. For example: If the url of web app on my prod env is
http://ipprod:port1/sites/abc/testingsite.aspxI can only access the restored web app if I access it using the url
http://ip:port/sites/abc/testingsite.aspx(PS - ip:port is ip and port of the development environment.)
I cannot access the restored web app on dev env using
http://localhost/sites/abc/testingsite.aspxbut i can access it using
I would be very glad if somebody can help me in clearing my concepts. Thanks.