.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

stsadm Import with includeusersecurity Messed Up Security in Collection

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint

I used STSADM to export a site then imported it to the same collection but a different URL. I used includeusersecurity for both. The export and import worked.

But this destroyed security for some unrelated higher level sites. One Active Directory group completely disappeared from all of the broken sites and putting it back only helped in some cases.

Trying to fix some sites has not worked at all. Changes made to their security has absolutely no effect. I had to add users into a different already used Active Directory group to get them into the broken sites and this AD group is not even listed within the broken sites security!

It's seems to be related to sites using Active Directory groups only. My sites with purely SharePoint groups seem fine.

I even created a new site at the same site collection level and security still doesn't work!


One recommendation, NEVER EVER USE INCLUDEUSERSECURITY. I have been burned twice now. IT BREAKS SHAREPOINT.

SharePoint Server 2007


Ken C

View Complete Post

More Related Resource Links

stsadm Import command + include user security



When I move sites from test to staging to production, I am using the stsadm –o export command with the –includeusersecurity option in the staging environment.  In production environment, I then use the stsadm –o import command with the –includeusersecurity option.  I was assuming that this option was bringing over the security on the exported site only.  This does not seem to be the case.

Last night I exported one sub site to produtction.  Today, I was notified that the security groups on other sub sites have been altered.  


So why is it when using the –includeusersecurity option effect all sub sites and not just the one sub site being moved from staging to production

stsadm export / import custom view / personal view views

Hi, i have to export and import a website with a sharepoint list including all personal views. The personal views are used by the endusers in excel data connections binded to the list.  Loss of personal views during import is not mentioned in the technet discription of export / import command ( http://technet.microsoft.com/en-us/library/cc766807(office.12).aspx  ) I am actually testing the export / import between two site collections, but always losing the personal views (MOSS 2007 with CU April 2010). This discussion had the same topic http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/4e299838-72c2-4f56-8dc3-05ba2a2999d9  but with no definite answer. Please tell me if this is by design or what could cause this behavior. Thanks in advance. Boris Boris Schlotthauer

What is the STSADM command to set a quota limit on a site collection?

I have a site collection that I need to make larger than the default size of 1GB.  I need to up it to 8GB's.  Can anyone give me the STSADM command that will do that?

STSADM command to add 'Site Collection Admins'?


Can someone help me with stsadm command to add user as site collection admin?

Issue with Picture Library Slideshow Web Part after export/import of site collection (SP2010)


I recently exported/imported an SP2010 site collection from Dev to Prod. The site collection had about 90 sites, which were all driven from a site template. Once the export/import had taken place, I created an additional 15 sites (in Prod), using the original site template that was created in the Dev environment. Everything seemed to be working just fine, but I found an issue with the Picture Library Slideshow Web Parts (PLSWP) on all the sites that were created in Prod. Basically, I have a Picture Library, and any pictures added to this library show up in the PLSWP. The original 80 site's PLSWP works fine, but the new 15 sites will not show the pictures through the PLSWP (the viewer just shows up blank). Here is the difference in the html output of the picture viewer:

 PLSWP from Dev:

 <a target="_blank" href="http://forefronttest/realestate/RE/West/HOU/3560/Project%20Pictures/test.jpg" id="MSOPictureLibrarySlideshowWebPart_ctl00_m_g_28b22a62_6d8

Newbie User Import Question re: One way external trust & Security



There is a business initiative to install a Dev Sharepoint 2007 server in our Trusting Domain. My internal corp network will be Corp.COM. The 3rd party network will be 3rd.COM.  Currently 3rd.COM has a Oneway External Trust pointing inward to Corp.com.  Corp.COM Domain and Forest levels are WIndows 2003. 3rd.com Domain level is Windows 2000 Mixed and the Forest is Windows 2000.

The Dev sharepoint server is located in 3rd.Com domain and the consultant is trying to import Corp.com users by pointing the user profile connection to Corp.com active directory. Needless to say this will fail because there is a one way trust in place so 3rd.com users are allowed to read Corp.Com active directory. Not to mention there are no firewall ports open for this anyway. My questions are...

How can we securely allow this sharepoint server to import in 3rd.com to import users from Corp.com?

Ideally we would like to use a service account from Corp.com to import the accounts. We would also like to either

(A) encrypt the sharepoint servers communication to our Corp.com active directory. because there are Two firewalls between the trust ports would be specifically opened from Sharepoint server <-> Corp.com DC

(b) some how use the existing trust to facilitate this procedures. no additional ports opened on the firewalls.

Any ass

Last modified by and last modified date changes after doing stsadm export/import


After doing an stsadm export/import of a document library, all the document modified dates are changed to current date and modified by changed to the person who did the import. How do I retain the last modified dates and modified by values as in the source library? I know we can preserve metatdata using the Manage content and structure GUI and saving as templates, but anyway to do it via stsadm?


STSADM Import giving outofmemoryexception


I'm trying to move few sites in one site collection to a nbrand new site collection. For that I'm trying to export the sites and import into to the new site collection using the below command

stsadm -o import -url http://localhost/tower3 -includeusersecurity -updateversions 1 -filename phsr.dat

and I'm getting the following error when I try to get a Production copy of the site and import into the Lab Server.

Export command I used is

<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-alt:"Calisto MT"; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-alt:"Times New Roman"; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-

sharepoint security groups, ACL of site collection or subsite need to move in to sql server 2008 usi


HI Team,

I am new to sharepoint here is my query. i am working on MOSS 2007, SQL server 2008

I want to move the sharepoint security groups, ACL(access control list), user groups all the security and permission related data to sql server 2008 from a particular site collection or subsite. After getting the data in to sql server we should be able to update the users from sql server itself which should reflect in sharepoint sites.

SharePoint Import/Export or other STSADM commands?


Greetings -

We are currently in the process of moving our MOSS 2007 environment over to a new server.  We currently have a single server farm (SQL, Search, Front End all on one box) and are splitting the SQL off to a SQL Server.  We have gone through the DB copy / restore for the new box.  When looking at the sites it appears that ONLY the servername/sites were moved over to the new SQL box.  We still have servername/pages and servername/sitedirectory, etc... that did not appear to move.  So if I go to servername/sites/executivesite it pops up fine but if I go to servername/sitedirectory/exectuivesite2 nothing. 

I started to do a export / import of the entire /SiteDirectory and ran into a size error when attempting to run stsadm -o -export "siteblahblah" -filename placetoputtheexportfile -includefilesecurity so I backed up the same sitedirectory using the -nofilecompression.  The export ran fine with no errors or warnings.  When I attmempted to do the import it went through but with the warning that (simplified) this data does not include the file security settings so it won't be imported".  It imported almost all the data except a few lists and document libraries and excluded almost all file security.  Is there a better way to do this or am I just going to have to keep banging my head till i

STSADM import fails with "FatalError: Save Conflict Your changes conflict with those made concurrent


MOSS 2007

I am importing a relatively large (10 GB) subsite and getting the following error:

[4/7/2011 9:05:05 AM]: FatalError: Save Conflict

Your changes conflict with those made concurrently by another user. If you want your changes to be applied, click Back in your Web browser, refresh the page, and resubmit your changes.
   at Microsoft.SharePoint.Library.SPRequest.AddOrUpdateItem(String bstrUrl, String bstrListName, Boolean bAdd, Boolean bSystemUpdate, Boolean bPreserveItemVersion, Boolean bUpdateNoVersion, Int32& plID, String& pbstrGuid, Guid pbstrNewDocId, Boolean bHasNewDocId, String bstrVersion, Object& pvarAttachmentNames, Object& pvarAttachmentContents, Object& pvarProperties, Boolean bCheckOut, Boolean bCheckin, Boolean bMigration, Boolean bPublish)
   at Microsoft.SharePoint.SPListItem.AddOrUpdateItem(Boolean bAdd, Boolean bSystem, Boolean bPreserveItemVersion, Boolean bNoVersion, Boolean bMigration, Boolean bPublish, Boolean bCheckOut, Boolean bCheckin, Guid newGuidOnAdd, Int32& ulID, Object& objAttachmentNames, Object& objAttachmentContents, Boolean suppressAfterEvents)
   at Microsoft.SharePoint.SPListItem.UpdateInternal(Boolean bSystem, Boolean bPreserveItemVersion, Guid newGuidOnAdd, Boolean bMigration, Boolean bPublish, Boolean bNoVersion, Boolean bCheckOut,

What speeds are you seeing in stsadm import and exports?



I am currently working on project where I am moving a site collection from one web application to another. This site collection is currently in a shared database with other site collections and I will be moving it to another database. 


This site collection is about 100GB in size. My export and import is taking about 8-10 hours each to complete. I am just wanting feedback from others if this seems to be normal or do I have some bottleneck in the environment. I have heard a good average is about 12GB per hour but wasn't sure if that is what everyone else is seeing. 

SharePoint Tutorial - Security

Security in SharePoint is comprised of users, groups and roles.

Users, Groups and Roles

A user account comes from the authentication system. For example, if Active Directory is used to authenticate then the user accounts will come from it.

There are two types of groups SharePoint uses: domain groups and SharePoint groups.

Import XML File to SQL Table

Here is a brief example of importing an XML file into SQL Server table. This is accomplished by using the BULK option of OPENROWSET to load the file, and then utilizing the XQuery capabilities of SQL Server to parse the XML to normalized table format. This example requires SQL server 2005 or SQL Server 2008.

First, the following XML is saved to XML file C:\Products.xml.

Asp.net web site security database


Hello all, I'm new to asp.net and I'm currently practising some few stuffs. I'm creating a hotel reservation system using ASP.net Web site in visual studio 2008 and I currently don't have an App_Data in my solution explorer unlike visual web developer.

1. I have planned to make users of the website login before making their reservations.

2. I have also planned to develop the website such that I will be able to know all reservations made by each user.

First and formost, I will like to know how I can access/View the security database?

Secondly, how do I link my custom made reservation database and the security database in order to achieve my second plan above.?

Someone help me.

Thank you.



hello i have the following problem

i have upload my content to hosting server but i get the following error

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SecurityException: Request for the permission of typ
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend