How to transfer site content DB from C drive to Other drive

Many a times we face an issue that c drive is out of space especially b'coz our site content db is on c drive and we continue to add large size documents and media files etc. In order to get rid of this we can transfer the db to some other drive say d drive with more space. Here is how you can do it:

Go to SQL server management studio and right click on the content db.
As chances are that this db is currently in use hence first take it offline.
It will take some time to take it offline. Once done right click detach the db.
Now go to the location on the c drive program files sql server folder and find the db files. Cut the files from there and paste in a new folder on d drive.
Again go to mgmt studio and attach the db from the new location.
Done

Comments

How to get SPUser or SPGroup from Person or Group field

You have person or group field in SharePoint list and you want to programmatically get the user or person. The below code to gets SPUser from User or Group field in the list when multiple choice and Groups are not allowed in the field: //get SPUser SPFieldUser userField = (SPFieldUser)item.Fields.GetField("Users"); SPFieldUserValue userFieldValue = (SPFieldUserValue)userField.GetFieldValue(item["Users"].ToString()); SPUser user = userFieldValue.User; This part of code would help you to get SPUser when multiple choice is allowed and groups are not allowed: //Multiple choices are allowed SPFieldUser userField = (SPFieldUser)item.Fields.GetField("Users"); SPFieldUserValueCollection userFieldValueCollection = (SPFieldUserValueCollection)userField.GetFieldValue(item["Users"].ToString()); foreach (SPFieldUserValue userFieldValue in userFieldValueCollection) { Console.WriteLine(" " + userFieldValue.User.LoginName); } And when group...

SharePoint publishing page scheduling

In SharePoint 2010 publishing enabled team site collection is not showing schedule button in publish ribbon. Solution: Here is how to enable it though the UI: Locate the SharePoint Server Web site on which you want to enable content approval and item scheduling. Click Site Actions , click Site Settings , and then click Modify Pages Library Settings . Under General Settings , click Versioning Settings . Click Yes next to Content Approval , and then click OK . Click Manage item scheduling . Click to enable the Enable scheduling of items in this list check box, and then click OK .

Changing Content Type Hub URL

Change the Hub URL through powershell by using: Set-SPMetadataServiceApplication -Identity " " -HubURI " " For Ex: Set-SPMetadataServiceApplication -Identity "Managed Metadata Service" -HubURI "http://contenttype.Domain.Com" When you try to do this you get this rather scary message: This is SharePoint telling you that this is a major thing so be careful! Essentially all your content types that you have published out will be removed if they can, and you have to republish all of your content types out again which can cause some issue.

SharePoint Secrets

Search This Blog