Solved

Sharepoint 3.0 STSADM command IIS

Posted on 2011-03-08
3
586 Views
Last Modified: 2012-08-13
Does any one know where I am going wrong with this code to add the content database and assign it a different ID?

stsadm.exe -o addcontentdb -url http://sharepointsite -assignnewdatabaseid -databasename Sharepoint_2DB
0
Comment
Question by:fstinc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
ThatSharepointGuy earned 250 total points
ID: 35073032
What isn't working (what does it say when you run your command)?

According to Microsoft you're doing it the right way:
http://technet.microsoft.com/en-us/library/cc288692(office.12).aspx

stsadm.exe -o addcontentdb

-url <URL name>

-[-assignnewdatabaseid]

-[-clearchangelog]

-databasename <database name>

[-databaseserver <database server name>]

[-databaseuser <database username>]

[-databasepassword <database password>]

[-sitewarning <site warning count>]

[-sitemax <site max count>]


One thing I would do, is wrap your URL, Database Name, and Database Server in quotes.

So try this:
stsadm.exe -o addcontentdb -url "https://mySharePoint.com" -assignnewdatabaseid -databasename "New-ContentDB" -databaseserver "MySharePointSQL" 

Open in new window


I know the server isn't "required", so you can leave that out if you want.  I usually supply server and credentials regardless, and haven't had any issues with it.
0
 

Author Comment

by:fstinc
ID: 35073671
Yup, the quotes seemed to have done they job. Didnt know that. Thanks.
0
 
LVL 6

Expert Comment

by:ThatSharepointGuy
ID: 35073959
No problem, fstinc!

I have a habit of wrapping everything in quotes, from URLs to server names, etc.  It doesn't always do the trick, but i've had more success doing it than without.  

Have a good one!
0

Featured Post

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question