Restoring ProdDB to DevDB, got an error
I am trying to restore same database with site collections to dev server. I took backup from production server. ("Content_80_webappProd"). But dev server has ("Content_80_webappDev). I am attaching Content_80_webappProd to dev server (made Content_80_webappDev" offline) getting unknow error. Is there anyone have steps to follow restore db from prod to dev?Jamsbond
February 4th, 2010 7:07pm
Hi,Please try the following- Associate restored DB with new Web AppCentral Admin->Application Management-> SharePoint Web Application Management->Content Databases->Remove Content Database from your web app.- Now use STSADM to add restored DB to this web appc:\program files\common files\microsoft shared\web server extentions\12\bin on new server is where you can find the STSADM.run this command from there.stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver- Run ISSRESET from command promptBest Regards, Ammar MCT http://ahmed-ammar.blogspot.com Posting is provided "AS IS" with no warranties, and confers no rights.
February 4th, 2010 7:15pm