.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Monitoring and moving SharePoint foundation 2010 database on SBS 2008

Posted By:      Posted Date: September 19, 2010    Points: 0   Category :SharePoint

I have successfully followed the white paper for upgrading SharePoint Services 3.0 to SharePoint Foundation 2010. Other than an authentication link problem all went smoothly.

I do have two small problems. The Small Business Server console reports that SharePoint is not functioning (it is functioning as I can connect to the site), this is more a nussance as my daily reports are inaccurate and I hope if this is normal there is or will be a hotfix to repair the reporting. This also comes to the second more serious problem.

In upgrading the process moved the database from it's own drive back to the system drive. I should have payed more attention to the directories in the upgrade process. Live and learn. Since the reporting is wrong in the console the move database wizard also does not work. Knowing that SBS gets cranky when things aren't done with a wizard or in a super specific order, is there a proper way to move the database? I am beging to get the long list of warnings as the drive fills up.

Any help would be appreciated. Thank you.



View Complete Post

More Related Resource Links

SharePoint 2010 Foundation - Standalone - SQL Server Express 2008 R2 - Moving databases to another d


Setting up a new install who will be using SharePoint Foundation 2010 in Standalone mode. They do not have SQL SERVER 2008 so need to utilize the Standalone option and the latest version of SQL Server 2008 Express R2. They are just getting started with SharePoint and it is unknown how much the technology will be embraced to afford to purchase SQL Server at this point. I wanted to get that explanation out of the way before everyone tells me the best practice of installing in Farm mode only! I realize the best practice but sometimes we have to roll with the punches because getting a client to begin using SharePoint on their current budget is better than never getting the chance to use it at all.

So SharePoint Foundation 2010 is installed with the default SQL Server 2008 R2 Express instance. Is there a procedure for moving the databases to a new drive? What is the default instance name that is created? I'm having a hard time locating that information in the documentation. I've done this before with WSS 3.0 without issue but wondered if there were any documents on moving the newest databases and what the default instance name is. Thank you in advance.


Move SharePoint Foundation 2010 database from SQL 2008 R2 Express to SQL 2008 R2 Standard.


Currently, our Sharepoint Foundation 2010 's is installed in same server with SQL 2008 R2 express hosting the databases. We would like to move all the Sharepoint Foundation 2010 database to a new SQL 2008 R2 Standard Server. Can it be done?

In this technet document, http://technet.microsoft.com/en-us/library/cc512725.aspx, it stated "The new database server must be running the same version of Windows Server and Microsoft SQL Server as the existing database server." Does it mean that I cannot move the database to  SQL 2008 R2 Standard Server?

SQL 2008 Standard Licence for Sharepoint 2010 foundation

Hello! We want setup sharepoint 2010 foundation with an SQL 2008 Standard. The expected amount of data are about 40 GB or more. This the reason why we can't use SQL Express 2008 R2. What Licencemodel is necessary ? - Do we need an Processorlicence, is concurrent ok or need only the Sharpoint Server a Licence for access the database. thank's in advance Christian  

Upgrading to SharePoint 2010 Foundation on SBS Server 2008

Hi all, I've just tried to install SharePoint Foundation on 2010 on Windows Small Business Server 2008 and whilst the literature I've found suggests that this is supported, I receive the following error: SharePoint 2010 Products cannot be installed in Stand-alone mode on a Domain Controller.  For more information on upgrading, see http://support.microsoft.com/?kbid=975805. What's funny about the KB ID, is that it doesn't exist.  The pre-requisites for SharePoint 2010 Foundation installed OK and the SharePoint installer has detected that it will perform an in-place upgrade.  the STSADM -o preupgradecheck output is below. Any idea's?  It would be really great if we could start using the shared workspace and ribbon features that are inherent with SPF2010. Jason.  

Problems with Report Services 2008 Integration in Sharepoint Foundation 2010

hi Folks, i ihave tried to solve my problem with this entry, but it has not fixed the issue. I would like to integrate RS in a Sharepoint Foundation 2010 environment, but when try to integrate the RS in Central Administration I am receiving the following error, see pic: Central Administration jpg When I try to access direct the RS Url the I get an access denied error please help.   thx a lot

Moving Sharepoint 2010 Database

I'm planning on moving our sharepoint (2010) database from one server to another (SQL 2008), however the MSDN method recommends we setup a SQL alias on the sharepoint server and use the detach/attach method. Surely there is a better method to change the database server name instead of creating an alias on the sharepoint box?  

Migrate from SPS 3.0 to SharePoint Foundation 2010 on SBS 2008

Good news is a white paper and technet article came out on how to do this.  Bad news is that it had a significant error, and when I downloaded to follow, it was the day before the correction. I have finished the migration almost, but there are some issues that manifest itself on IIS and in trying to attach the saved configuration database. When I launch SPF Management Console, I get a warning message that"the security token service is not available." I also get two application event log postings, the first an error and the second right after a warning as follows: Event ID 8306 Category Claims Authentication.   Description: An exception occurred when trying to issue security token: Could not connect to http://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc . TCP error code 10061: No connection could be made because the target machine actively refused it . Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event ">   <System>     <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6fb7e0cd-52e7-47dd-997a-241563931fc2}" />     <EventID>8306</EventID>     <Version>14</Version>     <Level>2</Level>     <Task>47</

Windows Sharepoint Foundation 2010 - Document Library Settings with Reporting Services 2008 R2 in in

I have a client who has recently upgraded their SharePoint system to Windows Sharepoint Foundation 2010 with Reporting Services 2008 R2 in integrated mode. I have configured reporting services and am able to deploy reports to SharePoint. The client created a document library before the upgrade to WSF 2010. I need to add Report Builder 3.0 to the New Document menu and found the following article. http://technet.microsoft.com/en-us/library/bb326289.aspx "Allow management of content types?" is set to yes under the advanced document library settings. The problem is that when I try to "add from existing site content types" the reporting services content types are not in the list. I appreciate any help you can give me.

Moving SharePoint 2010 Databases to from SQL 2008 to a new SQL 2008 cluster


Hello All,

I need to find the BEST way to move SharePoint 2010 databases from SQL 2008 to a new SQL 2008 cluster. I have searched the net and found that MS has a technet article to move the database http://technet.microsoft.com/en-us/library/cc512725.aspx and other Blogs that suggest using SQL aliases: http://stsadm.blogspot.com/2008/06/moving-databases-easy-way.html

My current delpoyment is currenlty undergoing development and not yet deployed to the public, and I am leaning toward creating a new farm and have SharePoint taking care of creating the many databases, then attach the content database to the web application.

I need the feedback from the forum to which approach is the BEST for my scenario, since my deployment is not yet public. Also, I would like to know if anyone has tried the steps described in MS Technet article: http://technet.microsoft.com/en-us/library/cc512725.aspx .



install Sharepoint foundation 2010 with windows 2008 WEB and Sql 2008 Web Edition



i wonder if it possible to install Sharepoint foundation 2010 with windows 2008 WEB and Sql 2008 Web Edition,





Reporting services and Sharepoint Foundation 2010 + SQL Server 2008 R2 RTM - Express with Advanced S



is possible use reporting services in Sharepoint Foundation 2010 if I have installed SQL Server 2008 R2 RTM - Express with Advanced Services? I tried various settings and configurations, but it not works (I am not able successfully configure Reporting Services Integration in Central Administration).

Now I am not sure that is possible use reporting services in SPF 2010 + SQL Server 2008 R2 RTM - Express with Advanced Services...

Thank you!

moving Team Foundation Server 2010 site to SharePoint 2010 farm.....

What is the best way to move a Team Foundation Server site over to our SharePoint 2010 farm? Can someone please point me to some documentation on how? Thanks,

SharePoint's Sandbox: Developing, Deploying and Monitoring Sandboxed Solutions in SharePoint 2010


The challenge in SharePoint development has always been the balance between creating and deploying solutions that you can trust not to damage or impair a SharePoint farm. A new feature in SharePoint 2010, called Sandboxed Solutions, enables farm administrators to feel comfortable that the SharePoint farm is safe, gives site collection administrators the authority to manage applications in their site collection, and provides developers with the flexibility to create solutions they know will be deployed in a safe and rapid manner.

Paul Stubbs

MSDN Magazine November 2009

How to upgrade from Windows SharePoint Services 2.0 to SharePoint Foundation 2010 after mistanely de


I need a detailed instruction on how to upgrade From Upgrading from Windows SharePoint Services 2.0  (SBS 2003 ) to SharePoint Foundation 2010.

Background of the case:

I have all my databases (STS-database and STS_Config) saved but, I forgot to save my Virtual Site )Companyweb site) and I mistakenly re-installed IIS on the SBS 2003, hence  I lost the companyweb site. Is this an issue to migrate to Sharepoint foundation 2010. The Sharepoint foundation 2010 is running on a Microsoft HyperV Server 2008 R2
Also, I have created a Virtual 2003 SRV ENT with Sharepoint Services 3.0 running on it. I also have attached my Databases STS_Database and STS_Config)... how do I get it working like a regular website. I have modified the CNAME record to reflect the new server... http://companyweb - it take me to the new site but it loads a blank page. I did create a new CompanyWeb Virtual site on the VHD 2003 server.
Your help is greatly appreciated.

Thanks for your prompt response. Nelson

Chapter 2: SharePoint Foundation Development (Inside SharePoint 2010)

Learn what's new with the SharePoint developer platform from experts on Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010.

Redeploying Customizations and Solutions in SharePoint Foundation 2010 and SharePoint Server 2010

Learn how to redeploy customizations and custom solutions that you created for Windows SharePoint Services 3.0 and SharePoint Server 2007 in SharePoint Server 2010 and SharePoint Foundation 2010.

Using the SharePoint Foundation 2010 Managed Client Object Model with the Open XML SDK 2.0

Write client-side applications that work with Open XML documents that are stored in document libraries by using these two technologies together.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend