Wednesday, April 27, 2011

Sound Bar With Blu Ray Player

Lesson Learned: Recovering SharePoint from 2 versions of a database

Scenario:

It has 2 versions of the same database at different times and need to unify this information into one.

Within a SharePoint farm is stored a unique ID for each site collection, so that can not hold even if on different Web Applications and Databases the same site collection.

Solution:

This requires creating a new SharePoint farm to another server and there to add the other version of database content.

Then use stsadm.exe-o export or Content Deployment Wizard is a free tool to create tablets (CMP) of the content you want to migrate to another database.

Note: You must have twice the space to migrate content. And in the operating system drive at least the size of what you want to migrate because the tablet needs to create enough space to create temporary files.

As this server is temporarily not partition installation on multiple disks is better to have a single unit of a good size double or triple the content that migration is both the origin and destination (resources sometimes difficult to achieve) .

For SharePoint 2010 we have much more power and options can line through command either by using stsadm or cmdlet to export a library or list, we can restore a database that is not attached to the farm so it is only necessary that this attachment to a SQL Server server. More information here

SharePoint4Fun, Manolo Herrera

0 comments:

Post a Comment