.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

Moving the sharepoint databases to another server

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :SharePoint
I have integrate TFS 2010 and SP 2010 but each of these app dbs are on different SQL servers and in different geograhics locations. ie TFS DBs are in location A and SP 2010 DBs are in location B, connected via a WAN.  SP 2010 is running slow and I am assuming it is because of this configuration that could be a main cause of this.  So I would like to move the SP databases onto the same server as the TFS DB's is there and easy way to do this?

View Complete Post

More Related Resource Links

Best practices on moving SharePoint databases physically, while keeping them on the same SQL server?

I'd need to move the SharePoint 2010 databases (preferably all of them) with as little hassle as possibly from one partition to another. I tried once, and ended up with a broken SharePoint and had to recover from backups. What's the best practices for moving the databases without breaking SharePoint completely in the process? I'm guessing I need to shut down the SharePoint server for this... That's not impossible if needed.

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.


need help moving System Center SQL Databases to new SQL Server about30 databases to be moved...

We are running various System Center products, SCSM, SCVMM, SCCM, DPM, OPALIS. and a few other servers all using the same SQL server, which currently is a VM. We have configured and built a new Physical box that will replace this. In the past we have moved SQL databases by doing a full backup and then restoring the backup on the new server, then renaming the servers, both network name and internal sql name.  This has worked fine in the past. However I've never had to move 30 databases before, nor have I had to move reporting services. Is there a better method. a recomended method? 

Moving a larger Sharepoint 2007 site collection over to a new server



We have a Sharepoint 2007 site collection roughly 36 GB in size and have been having problems moving the site to a new server farm (Also 2007). We are trying the Sharepoint backup and restore method, but I understand that this method is not recommended for sites over 5GB. Has anyone moved a site of this size and how did you do it?

Thanks  Ron


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 .



Moving SharePoint Database to non trusted domain SQL server



We have SharePoint and SQL server in a extranet domain. We would like move the SQL server databases for SharePoint to our corporate SQL server (on the corporate domain). 

The Corporate domain does not trust the extranet domain, and thus the web farm account cannnot be specified on the corportare SQL instance. If it possible to migrate the databases to a non tusted domain?

I've seen the script to create a new Config database using SQL authentication

psconfig -cmd configdb -create -server <SQL server name> -database <database name> -dbuser <SQL account> -dbpassword <SQL password> -user <AD user account> -password <AD user password>

Can I edit the config of SharePoint to point to the new SQL server, or do I need to create the entire sharepoint enviromnent again and attach the content databases?

I also have a SSP database that's heavily customised for searcvhing and the BDC. Will this need recreating again or can I move the BDC database  to the new server and attach?


Moving Sharepoint 2007 from Virtual Server 2005 to Hyper-V


I'm a little unsure of the exact sequence to move my Sharepoint 2007 Virtual server from VS2005 to Hyper-V.  In my enviroment, my sharepoint machine and SQL machine are on 2 different boxes.  SQL 2005 is on Hyper-V and Sharepoint is on Virtual Server 2005.  Do I shutdown the SQL VM before I move Sharepoint???   Will the new VM and SQL sync back up without any help??

Also, what happens to the SQL database if the new Sharepoint VM (on Hyper-V) has issues or problems??  Does that make my SQL server

out of sync with my old Sharepoint VM???  I have done multiple moves between VS2005 and Hyper-V so I really familiar with the process.

I usually keep the old VM around for a while after moving just in case there is a problem.   I can always blow away the new VM and crank up the old.   Viola!  I'm back to square one.

Any ideas??



moving sharepoint server 2007 to another domain


We are moving from our company location to another location with different network and different domain.at the first location we are using sharepoint server 2007 on windows server 2003

at the location that we are moving to,we are trying to install sharepoint server 2007 on windows server 2008,so I installed sherepoint server 2007,opened the site ,it got opened with me,took restore from the old company location,tried to restore it on the new location got error hresult ox80040e05,also when i tried to open the site ,i got error accesss denied

does moving sharepoint to different domain not on same network require more steps

Moving All Sharepoint Databases to different machine



I am having Sharepoint 2010 Enterprise RTM Trial (Single Server Installation) on Windows Server 2008 SP2 and Databases are managed by SQL Server 2008 (not r2).

I want to move backend Databases to another machine for better performance. I have read the following article:


I need to know is there any alternate that can migrate all databases with ease ?

can I take backup of all databases, then restore them on another server and make connection to Sharepoint ? (if yes, please provide necessary details)


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,

Copying SharePoint databases from single SQL server to clustered SQL servers, is it possible?



I am going to install SharePoint on load balancing servers - two front web servers, clustered database and on query server.

Since ordering the required hardware for clustering may take long time, my company decides to install SharePoint databases on single SQL server, and later on the databases will be restored on the clustered database server, any SharePoint configuration related to database will use DNS name not the IP address.

My question , in order to copy SharePoint database from single SQL server to clustered SQL servers ,Can we take backup from SharePoint databases (Content , Shared services ,Search …) from single  SQL server to be restored later on clustered SQL server? And then change DNS record to refer to the clustered IP address without any modification on SharePoint settings?



Move all databases (SharePoint Server 2010)



I've just run through the steps on http://technet.microsoft.com/en-us/library/cc512725.aspx to move all my SharePoint 2010 databases to a new SQL Server.

Initially the database was on the same server as my app (a full install, not single server farm) and I am trying to move them to a separate server. Both servers are running SQL 2008R2 and Windows Server 2008R2.

After reattaching all the databases to the new server, creating the alias on the web/app box and restarting all the services, I recieve the "Cannot connect to the configuration database." message when I try and browse to the Central Admin site.

What have I done wrong?



SharePoint Link list: After moving to prod, links still point to dev server


Hi all,

I have to move my dev site at http://localhost/sites/dev/ to the live environment at http://localhost/sites/live/.

On Dev server I have a lot of Link Lists with links pointing within the site.

******* Even if I enter a relative URL in Link lists, they are automatically converted to absolute URLs. I.e. /Lists/Overview will automatically be converted to http://localhost/sites/dev/Lists/Overview. ************

Now when I save site as template and move to to http://localhost/sites/live, the links in link lists still point to the dev server URLs (e.g. http://localhost/sites/dev/some page.aspx).

I read somewhere that saving site as site template and then moving to live server will automatically change links. This obviously doesn't seem to work for me.

Any help will be appreciated on how to migrate so that all links point to live site.

Thanks in advance.

Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Configuring User Profiles in SharePoint Server 2010

Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

Office Services: Merging Word Documents on the Server Side with SharePoint 2010


Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010

Gathering MOSS: New Dev-Centric Features In Office SharePoint Server Keep Your Apps Rolling


Microsoft Office SharePoint Server (MOSS) 2007 provides great portal and search features and much more, and Ted Pattison puts them to good use here.

Ted Pattison

MSDN Magazine August 2006

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