Archive for the ‘SharePoint’ Category
Good Links, February 5, 2009
Posted in Good Links, SharePoint on February 5, 2009| Leave a Comment »
Good Links, February 3, 2009
Posted in Good Links, SharePoint on February 3, 2009| Leave a Comment »
Understanding SharePoint inter-farm communications: http://blogs.msdn.com/uksharepoint/archive/2009/01/05/sharepoint-ports-proxies-and-protocols-an-overview-of-farm-communications.aspx
The right and wrong ways to iterate through SharePoint List items: http://blog.dynatrace.com/2009/01/11/the-wrong-way-to-iterate-through-sharepoint-splist-items/
Good Links, February 2, 2009
Posted in Good Links, SharePoint on February 2, 2009| Leave a Comment »
Application Lifecycle Management Resource Center for SharePoint Server : http://msdn.microsoft.com/en-us/office/cc990283.aspx
There you can find answers about (reference: http://blogs.msdn.com/pandrew/archive/2009/02/01/sharepoint-development-and-application-lifecycle-management.aspx)
- Team Development
- Source Code Control
- Automated Builds
- Continuous Integration
- Build Testing
- Unit Testing and Test Driven Development
- Solution Versioning
Good Links, January 30, 2009
Posted in Good Links, SharePoint on January 30, 2009| Leave a Comment »
Reserved SharePoint Query string IDs (FeatureId, ListTemplate, List, ID, VersionNo, ContentTypeId, RootFolder, View, FolderCTID, Mode, Type) : http://blogs.technet.com/stefan_gossner/archive/2009/01/30/querystring-parameters-you-should-not-use-in-your-sharepoint-application.aspx
SharePoint Dispose check tool, this tool will analyze assemblies that deal with SharePoint and tried to identify if all SharePoint objects used are correctly disposed: http://code.msdn.microsoft.com/SPDisposeCheck
A very quick way to restore SharePoint site collection (way quicker than stsadm -o backup/restore)
Posted in SharePoint on January 23, 2009| 4 Comments »
The conventional wisdom for moving a SharePoint site collection between farms is to backup the site collection using the stadm -o backup on the source server and then use stsadm -o restore on the destination server.
This approach is very neat and straight forward and works very well in most cases. The problem is with large site collections ( starting from a few GBs); with sizes in the GBs, this process might takes a very long time.
An alternative and much quicker way to backup and restore a site collection is using SQL Server backup and restore for the content database. SQL Server backup restore is way faster than stsadm backup/restore for large site collections.
Here are the steps needed:
- Identify the content database for the site collection. (in case you are not sure, check central administration->applications management-> content databases).
- From SQL server, backup this database and restore it to a new database.
- On the destination server, create a new site collection using the same template. As a result, a content database for the newly created site collection is created. ( note its name as we will delete it later from SQL server)
- On the destination server, go to central administration -> application management, content databases, Select the site collection and then select the existing database and remove it. Now the site collection has no content database.
- go to command line and use the command stsadm -o addcontentdb to attach the restored database to the site collection.
- Bingo ! ( in a fraction of the time needed for stsadm backup/restore)
Notes:
- You must first remove the existing content database before adding a new one. This is because it seems that SharePoint is looking for the top level site on that one and you must delete it first to force it to look for the top level site in the newly attached database.
- Trying to simply restore the database over the one just created by SharePoint with the creation of the new site collection will not work.