?
Solved

Sharepoint 3.0 STSADM command IIS

Posted on 2011-03-08
3
Medium Priority
?
620 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
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
ThatSharepointGuy earned 1000 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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month12 days, 19 hours left to enroll

579 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