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

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

What speeds are you seeing in stsadm import and exports?

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#


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. 

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

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 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 with includeusersecurity Messed Up Security in Collection


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

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,

Gridview that exports selected rows to Excel

his seems like a messy workaround, but I ended up using two Gridviews - one to display my data and show my checkboxes, and the other which was invisible amd would eventually end up as my Excel spreadsheet.

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.

xml import to database


Hello. I have XML document I use for backups..

I am using this code for importing XML to database:

protected void uvoziPodatkeXML(string backup, int tabela, string destinacijaTabela)
            DataSet reportData = new DataSet();

            FileStream filestream = File.OpenRead(lblPotIzvozi.Text + txtIme.Text + backup);
            BufferedStream buffered = new BufferedStream(filestream);

            //reportData.ReadXml(lblPotIzvozi.Text + txtIme.Text + backup);

            SqlConnection povezava = new SqlConnection(Convert.ToString(Session["cs"]));
            SqlBulkCopy sbc = new SqlBulkCopy(Convert.ToString(Session["cs"]), SqlBulkCopyOptions.KeepIdentity);
            sbc.DestinationTableName = destinacijaTabela;


But there is a problem when XML file is very large, larger than 50MB, it lasts forever to import to database.. I was searching over google, and saw that datasets are terrible slow for this operation.. I found some other methodes for use, but don't know there are no examples, that could help me.

Did someone work on this before?

thanks, yevgeni

XML Schemas: Take Advantage of Existing External XML Schemas with a Custom Import Framework in ASP.N


Over the years, many industry-standard XML schemas and dialects have been developed. These industry-specific schemas embrace the original purpose of XML and are extremely valuable in promoting and supporting B2B interaction. Unfortunately, the ASP.NET Web Services runtime does not allow developers to directly reference external schemas from within their XML Web Services interface (the WSDL file). This article builds an external schema framework as an extension to the ASP.NET Web Services runtime to enable you to reference external schemas within your XML Web Service interface.

Scott Short

MSDN Magazine December 2002

EF 4: Function Import problem with Stored Procedures


I have the following SP which includes a temp table:

 DECLARE @pos int

--create table to hold parsed values
CREATE TABLE #list (val varchar

BDC Import error with ADD


I want to try the BDC features so I created a test database with 2 tables related table (Building, Contact, Building has a foreing key to Contact). I used the Application Definition Designer furnished with the MOSS SDK to create the xml file. I was expecting it would be easy and straightforward but the produced xml file isn't working.

I get the following error when I try to import the Application definition:

Application definition import failed. The following error occurred: Entity could not be found using criteria 'name LIKE [SP_Test].[dbo].[Contact]'. Error was encountered at or just before Line: '140' and Position: '16'.

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.xsd" Type="Database" Version="" Name="Building" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
  <LobSystemInstance Name="Building_Instance">
    <Property Name="rdbconnectionData Source" Type="System.String">MOSS2007</Property>
    <Property Name="rdbcon

stsadm -0 copyappbincontent not updating all the appropriate Web Applications


On Sharepoint 2007 SP2:  "stsadm -o copyappbincontent" is not updating the web.config  in my (Sharepoint Central Admin) folder C:\Inetpub\wwwroot\wss\VirtualDirectories\xxxxx   .

It only updates the single web.config file in my C:\Inetpub\wwwroot\wss\VirtualDirectories\80     folder.

Without all web.config files and related content being updated, it prevents the use of certain functions within Central Admin-->.

What would prevent that stsadm command from updating all web.config files?

STSADM ActivateFeature takes too long



I have a solution installed to a web application, this Web App has a lot of Site Collections, these site collections were created with different versions of the wsp package. What I need is a way of activating the new features on the already provisioned site collections.

At first we made a Web Application scoped feature that went through all site collections that were using our template and then activated the features on each site collection but it was giving us a whole bunch of trouble were the code would skip entire site collections or enter the site collection, changing a field that we used for control and not activating anything... Now we have a Web scoped feature that activates all the features within the site collection at either Web or Site scope that we specify through an XML. This works like a charm for every site collection.

The problem is that we need a way of activating that feature on every site collection so I did a batch file that runs the STSADM ActivateFeature to do this. This also works properly but seing the many site collections that we have it is taking more than an hour and a half to finish the batch; is there a way of optimizing this so it runs quicker?

I think that the batch is actually waiting untill the feature is done activating to start to activate the feature on the next site collection, is there a way of a

sql server 2008 import/export wizard... completely useless??



import/export wizard in 2000 had lots of options.

I could copy databases without a care in the world. Including constraints, stored proc., AND the data, etc.

Now, with v2008, the wizard is dumbed down too much. It's a "stupid" copy function that fails on the first constraint it meets.

"Copy database.." is not an option here: it needs sysadmin on both source and destination server.

Re-adding the constraints manually is not an option either: the database is WAY too large. 

I'm actually hoping there is a temporary bug in the import/export wizard. Each option (and you have THREE...) returns with a new error.

Googling, I found I am not alone:


This post is exactly my situation. Here's what his post says: (bolded key parts)


I'm trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy.

Firstly I created a new empty db on the local machine. Then I scripted the structure of the db on the remote machine and ran the resulting query on the local machin

Error Consuming Web Service - Unable to import binding xxx from namespace ...


In VS2008 / C# / ASP.NET 3.5, I wrote a test web service app. Here is an extract from the code:

namespace emed.MathWebService
    /// <summary>
    /// Sample Math Services For Learning Web Services Deployment
    /// </summary>
    [WebService(Namespace = " http://localhost/MathService")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    public class MathService
        public float Add(float a, float b)
            return a + b;


I have published this to an IIS virtual directory named MathService, and when I try to launch it with the URL http://localhost/mathservice/MathService.asmx is works fine and displays all the operations (Add, Subtract etc) in the service.

I then created a test web application in VS2008 (named WebSvcTe

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