asked on

SharePoint Transfer

Hi,

Scenario: 2 sharepoint instances (2010 version). Both to be identical. Neither is on the same network so cant communicate electronically.

So say I backup the first the SharePoint instance when its in operation and restore it to the "new" instance. From then on what is the best way to keep them in sync on a daily basis?

I dont really want to have to restore from tape everyday. Is there some sharepoint or SQL tool that can let me extract the daily chnages in the db, put it onto some media and then import into the "new" sharepoint database.

Thanks

ASKER CERTIFIED SOLUTION

Member_6283346

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ted Bouskill

The way to achieve high availability with SharePoint is redundant hardware on one farm, not a hot standby. Even the 3rd party tools are risky in my tests.

On the farms I've built I use network load balanced front end servers and an Active/Active SQL cluster for the back end.

The problem is you can't backup/restore the entire configuration via the databases because if you read the Microsoft literature some core configuration DB's do NOT support backup/restore via SQL.

Many people do not implement a back up plan on SharePoint properly and backup databases that cannot be restored without damaging the farm.

Daryl Sirota

Is this for high-availability/disaster recovery? If so, use PowerShell to script a backup of each site collection to a file, and copy that file to removable media. Move the media to the target farm and execute a restore.

Because they are not connected, you'll have to manually move the data! The backup can be scheduled, and while you can poll for the existence of the media on the target, you'll still have to manually insert media!

If you need help with the powershell, let me know.

This will work for content databases, not for the configuration, search, etc. It also assumes the target is read-only, and no changes are made that can't be overwritten by the restore.

58872

ASKER

Thanks, soory for the delay.