-assignnewdatabaseid and those Content Database ReAttach Blues...
Hi there folks! Am going through a bit of a review enumerating users and sites using good ole stsadm across my webapps, and when trying to do this against one of the web apps get the following error:The site http://mycoolsite could not be found in the Web application SPWebApplication Name=SharePoint - MyCoolSite Parent=SPWebService.I thought this might have something to with the content database association to the Web Application, so got a shock when visiting the Content Databases page within the CA associated with the Web Application. No Content Databases was listed!Ok, so I thought - is there a site collection list relevant to the web app? Check Site Collections List in the CA... None listed!Ok, so I thought lets go in an re-attach the content database to the Web Application - when trying to do that got another message:"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."Mmmm...Ok, so lets attach the content database - checked the command:stsadm -o addcontentdb to check out the syntax... Looks fair enough... Wait...No '-assignnewdatabaseid parameter' in the command structure listed... Ok... so lets google -assignnewdatabaseid - strange? nothing!Ok, so lets try a full addcontentdb command as instructed...stsadm.exe -o addcontentdb -url http://mycoolsite -databaseserver MyServer\SQLEXPress -databasename MyCoolSiteContentDb -assignnewdatabaseidResult? Fails with 'Command line error. Invalid parameter'Try it without the -assignnewdatabaseid Result? Operation Completed Successfully.? So question one: Where is this wonderful parameter -assignnewdatabaseid - Has anyone come across the -assignnewdatabaseid parameter? - is it superceeded ? am running version 6219!? Another two questions. The content database being attached as almost 200 team sites. If I use the relevant stsadm -o addcontentdb with the -assignnewdatabaseid parameter, would I still be able to enumerate the users and sites relevant to that web app? Would I be able to see the site collections relevant to the web app?Any advice on this one appreciated! Cheers Geoff
December 22nd, 2008 6:37pm

HiGeoff, Your Server version is 6219, that means you have SP1 installed. However, the assignnewdatabaseid parameter was first introduced in the Infrastructure Update which version number is 12.0.6320.5000. That is why you come across No '-assignnewdatabaseid parameter' in the command structure listed exception. For your rest two questions, the best way is to do a test in the test environment. And I don't think the assignnewdatabaseid parameter would impact the sites in the content database. See Addcontentdb: Stsadm operation (Office SharePoint Server) (http://technet.microsoft.com/en-us/library/cc263422.aspx) for more information. Hope the information can be helpful. Merry Christmas! -lambertPosting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
December 24th, 2008 10:53am

Absolutely beautiful. If you are familiar with Google search, you will notice that googling: -anything, tells Google to NOT return pages containing that word. So if I google: -assignnewdatabaseid, I get no results. If I google: stsadm -assignnewdatabaseid, I get results for all pages containing stsadm, that do NOT include the word assignnewdatabaseid. However, surrounding your query with "" marks, will tell Google to not treat the - as a logical operator. In otherwords, you should search for "-assignnewdatabaseid", and you'll get a plethora of results that are probably exactly what you're looking for. Kudos, - Doug :-)CCNA, MCP, Security+, Linux+, Server+, Net+, A+, MSSBS
June 7th, 2010 10:10pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics