.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

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

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

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?

View Complete Post

More Related Resource Links

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  

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.



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.


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.  

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

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.

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,





attach sample database failed in sql 2008 express RTM

I'm having a trouble attaching sample database northwnd database,screen show me the error attach database failed for server 'computername\sqlexpress' additional inforamtion: the database 'northwind' cannot be opended because it is version 661.this server supports version 655 and earlier.a downgrade path is not supported.could not open new database 'northwind',create database is aborted,()microsoft sql server,error:948) my os is xp sp3,sql express version is  Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)   Jul  9 2008 14:43:34   Copyright (c) 1988-2008 Microsoft Corporation  Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)  I 'm sure database 'northwind' is ok.I can used database 'northwind' on my other computer.the other computer install express 2008R2 .    install RTM computer  ,database route is C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS,not C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. actually I 'm install sample database in sql express RTM on my computer.I just wonder why attach good database failed,how to solved this issue. http://sqlserversamples.codeplex.com/releases/view/45923 this link is avialable   thanks for you help

SQL 2008 Express with advanced services and Visual studios 2010

Hi could someone please help me. Im running the following software: SQL 2008 Express R2 with advanced services Visual Studios 2010 Ultimate   I am trying to using Sql in Visual studios to use full text indexing but I am attaching a database that already exists. My problem is that I can use the full text indexing? I had it working once but then when i tried to FREETEXT search through my table it said that I didn't have an index on that table when I know I do cause I went to make sure. I think that perhaps its referencing the wrong database because I cant seem to add the database into my project? I am so confused as to how SQL express instances work so not sure what I am doing wrong? PLEASE HELP? 

Move (detach/attach) db from 2008 Enterprise to 2008 Express

Hello I just thought about this question. Is it possible to create a database on a SQL 2008 Enterprise edition and move it to a SQL 2008 Express edition or would i run into the same version problems as when moving from 2008 to 2005? The reason for this is that i have a virtual Dev environment that has SQL 2008 Enterprise edition installed and now i get a project that is to run on SQL 2008 Express. It would be nice if i could skip installing the express edition and work against the Enterprise edition until deployment. Thanks ps. wasn't sure if this was the right forum to post this in. Please let me know if there was a more appropriate place for this.

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 database display in visual studio 2008 express?

I jsut installed SQL server and management studio on my PC. For management studio, I created a database with tables. However, When I have data connection for SQL server in visual studio express, I couldn' t see the database I created. Any recommendations?   Xinguo  

Procedure to move all SP 2010 databases from SQL 2005 to SQL 2008 R2

I have a single SharePoint 2010 WFE with a single SQL 2005 64-bit backend.  I need to decomission the SQL 2005 server.  What is the best procedure to move all the SharePoint associated databases to SQL 2008 R2? I have already read this MS doc on moving all databases: http://technet.microsoft.com/en-us/library/cc512725.aspx So the actual move procedure is standard SQL fodder. What I'm not clear about is what to do about the "other" SharePoint databases and how to reassociate them once the DBs are on the new SQL server.  For example, the Usage and Health DB is going to "Wss_Logging" and it specifies my old SQL server.  It is greyed so I cannot chagne it in Central Admin.  How do I let SharePoint know that these databases have been moved too?

HTTP 500 After Sharepoint 2010 Install on Win 2008 R2

Environment specifics: Windows 2008 R2 SQL 2008 (Version: 10.0.2746.0) No internet connection so I installed all the prerequisite software. I have two domain accounts: SPAdmin and SPFarm SPAdmin is what I use to install Sharepoint. SPFarm runs the app pool, timer service etc. Domain: Development domain. Scenario: After the SP Setup Wizard, Central admin is inaccessible and gives a HTTP 500 error. I checked the recommended permissions for both accounts and they both appear to be in the correct groups. The only way I can get it to work is to add the SPFarm account as a local admin. So it appears to be a permissions issue. But I can't figure out what the issue is or even where to start. Any advice would be greatly appreciated.

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