How to add secondary data file to SQL 2008 R2

Suppose your content DB has unrestricted growth but the disk where it’s places in restricted.

If more users pull more data to DB – and a DB is unable to growth, you’ll see a lot of errors like

<nativehr>0x80131904</nativehr><nativestack></nativestack>

or

[COM Exception (0x80131904): <nativehr>0x80131904</nativehr><nativestack></nativestack>]

Microsoft.SharePoint.Library.SPRequestInternalClass.AddOrUpdateItem

[SPException]

Microsoft.SharePoint.SPGlobal.HandleCOMException(COMException comEx)

Microsoft.SharePoint.Library.SPRequest.AddOrUpdateItem()

Microsoft.SharePoint.AddOrUpdateItem()

Microsoft.SharePoint.UpdateInternal()

Microsoft.SharePoint.SPListItem.Update()

That means there is no free space in SQL database. And if you couldn’t delete anything to get a free space?

The workaround is adding asecondary data file to your database.

http://technet.microsoft.com/en-us/library/ms189253.aspx http://stackoverflow.com/questions/2707403/what-are-ndf-files

How to add secondary data file to SQL 2008 R2

SharePoint Wiki Markup

wiki markup

For example typing the [[ characters will present a drop-down menu of available items to choose from

/SitePages/How%20To%20Use%20This%20Library.aspx

 

Wiki Links

Placing double square brackets around content creates a link to a page of that name on the root of the site. e.g. [[Home]] links to the page /Home.aspx and displays the link text Home.

Linking to content in sub folders can be done using forward slashes between directories in the path. The text displayed will be the name of the page. e.g. [[subfolder/Demo]] links to the page /subfolder/Demo.aspx and displays the link text Demo.

You can change the text displayed on a link by using the Pipe (|) character to separate the link’s path and link text. e.g. [[subfolder/Demo|See a demo]] links to the page /subfolder/Demo.aspx and displays the link text See a demo.

SharePoint Links

You can also link to other content within the same SharePoint site. For example, if you have a list called Tasks you can link to it via [[List:Tasks]]. Again you can use pipe characters to amend the displayed text.

To link to an item within that list, use the item’s Title; e.g. [[List:Tasks/Example Item]]

Character Escaping

Certain characters/strings can be escaped by placing a backslash before them. These characters are [[, ]], \[[ and \]].
Wiki Linking will not work within Content Editor Web Parts!
http://www.sharepointanalysthq.com/2010/05/wiki-linking-in-sharepoint-2010/

SharePoint Wiki Markup