tag:blogger.com,1999:blog-34081484.post1565679966845683222..comments2023-08-01T03:46:25.457-07:00Comments on Metahat: Backup / Restoring SharePoint 2007 Site from SQL DatabaseRags Iyerhttp://www.blogger.com/profile/14307129407990925912noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-34081484.post-33178075764088835472012-11-30T10:27:46.463-08:002012-11-30T10:27:46.463-08:00Hello,
I tried:
stsadm -o addcontentdb -url http:...Hello,<br /><br />I tried:<br />stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver<br /><br />but when I run it I have an error:<br />c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsa<br />dm -o addcontentdb -url http://windows7.yyyyyy.com -databasename WSS_window<br />s7_content -databaseserver VOTSPRSTR2\MSSQLSERVER<br /><br />The server instance specified was not found. Please specify the server's addres<br />s and port.<br />Any idea?<br />Thanks<br />DOmDominiquehttps://www.blogger.com/profile/01255525778656066370noreply@blogger.comtag:blogger.com,1999:blog-34081484.post-38620907683697749842011-12-23T02:57:44.571-08:002011-12-23T02:57:44.571-08:00After reading this post, it seems that this backup...After reading this post, it seems that this backup/ restoring method is much easier than other one Central Administration, Stsadm.exe. I will also check this method & let you know if I found any problem!! Thanks :)..SharePoint Server Recoveryhttp://www.stellarinfo.com/database-recovery/sharepoint-recovery/sharepoint-server-recovery.phpnoreply@blogger.comtag:blogger.com,1999:blog-34081484.post-62788071074704868542010-07-12T06:33:11.082-07:002010-07-12T06:33:11.082-07:00Nice Article works like a dream !. Always remember...Nice Article works like a dream !. Always remember if there is other code deployed or web.config changes these also may need restoring.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-34081484.post-4516168285254482732010-04-29T12:44:19.514-07:002010-04-29T12:44:19.514-07:00Worked like a charm for me (regular content databa...Worked like a charm for me (regular content database). Thanks!Tyler Holmeshttps://www.blogger.com/profile/16288716879251803370noreply@blogger.comtag:blogger.com,1999:blog-34081484.post-24825383972462372912010-03-08T06:18:40.550-08:002010-03-08T06:18:40.550-08:00Hi, please bear with me as I'm still new to SP...Hi, please bear with me as I'm still new to SP. I get this when I run the command:<br /><br />"The attach operation cannot continue because another object in this farm already contains the same ID. Each object in a farm must have a unique ID. In order to proceed with the attach operation you must assign a new ID to this database. To attach this database with a new ID, use the "stsadm.exe -o addcontentdb" operation with the -assignnewdatabaseid parameter. Note that if this new database and an existing database contain the same site collections, attaching this database will likely result in orphaned site collections due to conflicts between the two databases.". It is refering to the restored database that I want to associate with my new web app. Please help.Leratonoreply@blogger.comtag:blogger.com,1999:blog-34081484.post-451015866122626432009-11-11T19:10:10.511-08:002009-11-11T19:10:10.511-08:00Step 6: Run IISRESET, not ISSRESET. TypoStep 6: Run IISRESET, not ISSRESET. TypoAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-34081484.post-3529624309235141602009-10-30T08:00:29.584-07:002009-10-30T08:00:29.584-07:00Even could successfully restore content DB, create...Even could successfully restore content DB, create a new web application, remove its DB and attached the restored DB. However the site is missing.Payal Vyasnoreply@blogger.comtag:blogger.com,1999:blog-34081484.post-75272793972345862632009-02-12T08:24:00.000-08:002009-02-12T08:24:00.000-08:00Hi,i tried for mysite content DB restore but mysit...Hi,<BR/>i tried for mysite content DB restore but mysite content DB was restore successfully but somehow some of mysites are missing. any suggestions?Anonymousnoreply@blogger.com