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

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

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

Posted By:      Posted Date: October 10, 2010    Points: 0   Category :SharePoint

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.


View Complete Post

More Related Resource Links

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!

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.  

Visual Studio 2010 can't find the Sharepoint Foundation 2010 Server when compiliing, Standalone vs

I'm wondering if we installed Visual Studio correctly cos when we get into Visual Studio 2010 the "Deploy as a Farm Solution" is the only available button option and the "Deploy as a Sandbox Solution" is un-selectable, grayed out, assuming the "Sandbox" solution is the "Standalone" approach? So when we go to compile a Workflow, the error message says the Sharepoint Server is not found" Could this "Deploy as Farm Solution" be a problem when we were instructed to install Sharepoint 2010 Foundation as a "Standalone" install? in other words we're trying to find out why when we go to compile a Workflow in Visual Studio 2010 that it can't find the Sharepoint Server Step 3: Install SharePoint 2010 1.  To install SharePoint Server 2010 or SharePoint Foundation 2010, open a Command Prompt window, and then type the following at the command prompt: On the Choose the installation you want page, click Standalone to install everything on one developer workstation. Thanks very much for any suggestions, ideas or pointers! BobK

Monitoring and moving SharePoint foundation 2010 database on SBS 2008


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.



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 .



Sharepoint 2010 Foundation with Search Server Express


I have Sharepoint 2010 Foundation with Search Server Express installed. The Sharepoint was an upgrade from WSS v3 and search server express 2003.

After the upgrade whenever users search from the main site I get web part errors displayed on the search page. I think because it is trying to use the old search server express which is no longer installed.

Search Server Express 2010 is now installed and a Search Center web page can be viewed however when searching via the entire sites I site the web page with web part errors.

Any thoughts or any further information you require I can provide.

Sharepoint Foundation 2010 and Search Server Express


Can I get some clarification on a couple of points?


Firstly, what is the recommended installation path for SPFoundation and Search Server Express on the same server.  Do I just install SSE 2010?  Or SPF 2010 and then SSE 2010?

Secondly, when the two are installed together how do I add the a SSE 2010 search center link to my SPF 2010 site so I can search all crawled content?  I've created crawls of Exchange public folders and file shares but when I use the built-in site search box it's only returning content crawled from the local site and not anything from the other crawls.



Integrating Sharepoint Foundation 2010 and Search Server Express

I've been searching for ways to do this but I haven't come up with anything.  Surely this is a very common need/want.  Basically I want to use Sharepoint Foundation 2010 but I would like to run Search Server Express in the same installation.  Additionally instead of going to a dedicated search page and then searching, I'd like to add the Search Server Express search functionality as a Web Part to the Sharepoint Foundation home page.  Is there any documented procedures to this?  If not how have you done it?

Sharepoint 2010 Foundation vs Search Server 2010 Express


Does Search Server 2010 Express include Sharepoint Foundation? Or do I need to install Sharepoint first and then install Search Server on top? This is for a brand new install on a single server.

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,

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?

SharePoint Foundation - Search Server Express 2010 "upgrade" ?


I have an existing install of SP2010 Foundation. Can I just install Search Server Express 2010 on the WFE server and connect it to the existing farm? Or can I "upgrade" SP2010 Foundation to Search Server Express 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.

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

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  

Sharepoint Foundation 2010 to Sharepoint Server 2010

Hi there, We have Sharepoint Foundation 2010 already installed on Windows Server 2008, which uses SQL Server 2008 R2 Express (64 bit). There are sites already created and Custom lists and workflows. We then purchased a Sharepoint Server 2010 license. Is there an easy way to upgrade our current sharepoint using the same Database (Content DB). How do I deploy this new Sharepoint (on top of the Foundation) Worst case scenario: I have to remove Sharepoint Foundation and then install the licensed "Sharepoint Server 2010" version Please advise

how to make working WPF 2010 program make changes to SQL Server 2008 Express files

(1) I have a working WPF 2010 program that manipulates a table in SQL Server 2008 Express (2) the program does delete, update, select and insert correctly however in its own project file folder logbooklmk.mdf   logbooklmk_log.ldf (3) I want the actual SQL Server 2008 express files to be changed yes I know the issue is sharing and the copy option only applies to the local project files. I found this out by trying always copy, never copy and copy if newer. I probably have to change the .xsd folder to refer to the actual SQL Server 2008 Express file. Tried that once and it failed. Something about sharing not allowed.
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