.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

mergecontentdbs successfull... with data loss

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint
With the December 2007 release of SP1, a new stsadm command was introduced: mergecontentdbs. I had the opportunity to use this wonderful new command just a few weeks ago (saving my bacon from a rogue site collection which caused upgrade failure--fortunately I had the October 9, 2007, Security Update which gave me the mergecontentdbs command--SP1 upgrade would fail without getting rid of the rogue). Sadly, I learned a week after using the command in our production environment that it ever so conveniently deletes all content from lookup fields with multiple selections. Not even the versioning information is kept; the field only has to allow multiple selections; and, it even affects user/group fields! Talk about get egg on my face when I asked one of our groups where their data had gone!

Turns out, this specific problem is documented and corrected in the April 2009 CU (KB968857). Ironically, the KB was last updated just three days after I used mergecontentdbs and lost our data. Sure do wish something had been discovered sooner than a year and half after initial release. We are now scrambling to avoid insecurity in the stability of the SharePoint product amongst it's users and administrators.

To head off any further conflicts with our users, I would like to scan all of our site collecti

View Complete Post

More Related Resource Links

To prevent possible data loss before loading the designer, the following errors must be resolved: In

To prevent possible data loss before loading the designer, the following errors must be resolved: The class Form can be designed, but is not the first class in the file. Visual Studio requires that designers use the first class in the file. Move the class code so that it is the first class in the file and try loading the designer again. Instances of this error (1) 1. Hide Call Stack at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.EnsureDocument(IDesignerSerializationManager manager) at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager manager) at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager serializationManager) at System.ComponentModel.Design.Serialization.BasicDesignerLoader.BeginLoad(IDesignerLoaderHost host) Thanks! This post is from Matthew Cenance.

Why are there inconsistencies regarding data loss between subscribers on WAN vs. LAN links?

There are 6 subscribers, some of which communicate through a WAN (slow) link and some on a LAN (fast) connection to the distributor. An article on the publisher is filled with 13 million rows inserted via 13,000 separate transactions. For the next couple of hours the following events occurred and status was verified. 1.     The log reader was able to post commands into the distribution database without issue. We could see the commands posted for the 13 million rows inserted via 13,000 separate transactions. 2.     The distribution database was altered adding another data file to counter an impending drive space issue.  3.     More data modifications were made to other articles and new articles were added to the publication. After a couple of more hours the following events occurred and status was verified. 1.     Subscribers on LAN links were missing part of the data from the 13 million rows inserted via 13,000 separate transactions data modification (#1 above list) and other data was missing from more data modifications made to other articles (#3 above list). 2.     Subscribers on WAN links were NOT missing any of the data modifications. The current hypothesizes are… 1.     The distribution agent read and executed commands from the d

Socket receiving Data Loss

Hi Friends,   I have a Real Time Client/server application which should process received data and send back result with in milliseconds.Application is working fine when it runs in normal load. During my testing phase i tested by sending 100 message to clients in One seconds, But Client Application will only process 40 message , But sever will send all 100 message to clients. I would like to know Is there any DATA LOSS occurring in Client Side. Here is the code i wrote to receive data from sever. Private Sub sockDataArrival(ByVal ar As IAsyncResult) Dim state As StateObject = CType(ar.AsyncState, StateObject) Dim client As Socket = state.workSocket Dim bytesRead As Integer Try bytesRead = client.EndReceive(ar) Catch Exit Sub End Try Try Dim Data() As Byte = state.buffer If bytesRead = 0 Then client.Shutdown(SocketShutdown.Both) client.Close() RaiseEvent onDisconnect() Exit Sub End If ReDim state.buffer(50000) client.BeginReceive(state.buffer, 0, state.BufferSize, 0, AddressOf sockDataArrival, state) RaiseEvent onDataArrival(Data, bytesRead) Catch RaiseEvent onError(Err.Description) Exit Sub End Try End Sub Any Idea about this.....?  Dheeraj PK http://dheerajpk.spaces.live.com/default.aspx

Import Wizard fails because it is scared of potential data loss


I have a monthly reporting process that requires that I pull data from one system (System A) and load it into SQL Server (System B), the system I'm pulling from generates a .CSV file.  I have a table already built in SQL server to load the data in to with the exact same column names as the .CSV and the datatypes match those that are in System A.

However when trying to load the .CSV via the import wizard it fails because it thinks there is the potential for data loss.  Is there a way to override this overbearing tendency? Because the datatypes match there should be no way that data is lost.

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Dynamic Data Templates in GridView ASP.NET 3.5

At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Displaying Data using ASP.NET 2.0 Repeater and C#

This tutorial will show you how to display data using the .NET Repeater Control, ASP.NET 2.0 and C#.NET

The Repeater control is a powerful tool and is easy to use.

First, you will need to import the System.Data.SqlClient namespace.

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

ASP.NET 4.0 Dynamic Data and Many to Many Entity Framework Entities

I did not play much with Dynamic Data controls in VS2008 and just made a cool discovery in VS2010 Beta 2. This may not even be new, but as I'm sitting 30,000+ feet over the Atlantic ocean, I don't have access to VS2008 at the moment to check.

Display data in gridview dynamicallay

I have AD domain which has 100000 users, I want to display all the users in gridview controls.Actually it is displaying users in gridview after parsing entire domain which takes around 30 min. I want to display the users while loading itself.It is continously getting user information from AD domain and getting each user details, I want to display the users information which already queried instead of waiting till getting all users information

asp.net display data in gridview

i want to display data in gridview binded to a sql datasource
but the problem part is i want to bind a field of that datasource to a dropdownlist and when a item is selected in that dropdownlist then correcposnding to that data will be displayed in gridview...

display data into GridView from excel sheet

I have to display data from excel sheet into my gridview and also I need to figure out a way to store data into excel files from my web page. I am using C# 3.5, VS 2008.

GridView control to show master-child or master-slave data, written in c#, asp.net

I previously made a master slave datagrid using Visual Studio 2003 .Net (original article) that would allow users to show data to clients using collapse and expand features. These features however did not carry over to gridview for many users. This tutorial will explaing how to create a collapsable/expandable gridview in frameworks 2.0 and higher
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