Microsoft Sharepoint Server 2007, 2010 & 2013

Database AddcontentDB stsadm.exe -o addcontentdb            -url   -databasename            [-databaseserver ]            [-databaseuser ] DeletcontentDB stsadm.exe -o deletecontentdb  -url            -databasename            [-databaseserver ] Feature Activatefeature    stsadm.exe -o activatefeature            {-filename | -name | -id }            [-url ]   [-force] Deactivatefeature    stsadm.exe -o deactivatefeature            {-filename | -name | -id }            [-url ]...

http://msdn.microsoft.com/en-us/library/ms472236.aspx Create a site content type based on the Document parent content type On the Site Actions menu click Site Settings and Modify All Site Settings . On the Site Settings page under Galleries , click Site content types . On the Site Content Type Gallery page, click Create . On the New Site Content Type page, type a Name for the content type (for example Samples), select Document Content Types from the Select parent content type from drop-down list box. Select Document from the Parent Content Type drop-down list box, select Custom Content Types from the Existing group drop-down list box, and click OK . On the Site Content Type page under Settings , click Advanced settings . On the Site Content type, Advanced Settings page, select Upload a new document template , and then click Browse to browse to and select the excel document ...

dotnetguts

Database Changes: Take Backup of the current content database of myrtb site(2007 site) from SQL Server. In SQL Management Studio, create new DB and restore the content database, need to change an option in the "options" tab of the restore dialog to get it to work. (Overwrite db). Site Changes: Create a "New Web Application" in SP2010. Remove Content Database of newly Created site. c:\program files\common files\microsoft shared\web server extentions\14\bin. stsadm -o deletecontentdb -url http://*** -databasename -databaseserver . Now restore the DB to the created Web Application from STSADM stsadm -o addcontentdb -url http://*** -databasename yourcontentdb -databaseserver yoursqlserver

SPD Workflow How to create a workflow that copies a list item to another list for this we need basically two lists " Test1" and Test2". 1. Open Sharepoint Site in sharepoint Designer 2. From Ribbonbar click List workflow select the list to create workflow. 3. Enter the Workflow Name. 4. From the ribbonbar click "Condition" from common condtions click "If any value equal value" 5. Write the condition. Here I am writing the source list “Field” equal to destination list “Field”. For writing this codition follw the below steps. a.    Select source list field . b.    Select the Condition from condition dropdown and select the Destination list field. 2.    Now, click on the Actions button to perform what action to be done if the condition is satisfied. 3.    Select ‘Set Field in Current List” Action”, It will display Set “Field” to “Value”. 4.    Click Field hyper link it will show current list field name. ...

Ghosting means process of requesting an uncustomized page instance by using a page template loaded into memory from the file system of the front-end Web server. These Ghosted pages are pulled from the cache at runtime and therefore it will increase the scalability from the system. All uncustomized pages are reused across all the sites and there is no unnecessary data storage or retrieval. Ghosting eliminates the need to transfer the contents of a page definition file from the SQL Server computer with the content database to the front-end Web server computer For example, the default home page is a ghosted page. Any web part pages created via New Web Part Page user interface also ghosted. Unghosting means that the site has been customized. When you customize a site in SharePoint Designer, or you add custom fields to a Document Library, or create sites using that template; then the changes that you made are stored in the database as a difference and that is referred to as Unghost...

Using lockdown mode on published sites if greater security on these sites is a requirement. Additionally, if you applied the Publishing Portal site template, determine if lockdown mode is the desired configuration for these sites. If not, use the Stsadm.exe command-line tool to turn off lockdown mode. Turn off lockdown mode for a site collection stsadm -o deactivatefeature -url -filename ViewFormPagesLockDown\feature.xml Turn on lockdown mode for a site collection stsadm -o activatefeature -url -filename ViewFormPagesLockDown\feature.xml