.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

Moving Databases between Drives

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :SharePoint
I have Sharepoint WSSv3 running and configured as a farm, using SQL 2008 Express on the same server and wondered what steps i would need in order to move the database from the C:\ to the E:\ (on the same server). I have been told in a previous thread to detatch the db and move the files and reattach the db, but then someone replied Don't forget to change the default paths so the subsequents DBs are created on E:?? What Default Paths?? what i was going to do is: Stop all sharepoint and sql services detach the db move all databases onto the E:\ reattach the db restart the sharepoint and sql services Is this correct??

View Complete Post

More Related Resource Links

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? 

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.

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 - 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.


Drives used for SQL databases are running out of free space



I got the following error in my Health Analyzer, and have not been able to solve it, yet:

Drives used for SQL databases are running out of free space

The following databases have one or more files that may exceed the available free drive space. If this happens, operations will start to fail.

WSS_Logging on SQLC02\APP

Examine the drives containing the specified databases' log and data files.  Free space on these drives or move the database files to another drive.  A drive should have enough free space for the largest database file on it to autogrow twice. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=163560".

My database file is 7GB and the log file is 50MB. My database drive is 100GB and my log drive is 50GB.

Any suggestions how to solve this?


Best regards,


Moving the sharepoint databases to another server

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?

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)


Toolbox: Manage databases, easier FTP, and clustered caching


This month's products include DatabaseSpy, FileZilla, NCache, and more.

Scott Mitchell

MSDN Magazine October 2007

Toolbox: Analyze HTTP Traffic, Synchronize Databases, and More


Debugging Web applications can be a difficult process due to the logical, physical, and temporal differences between the mishmash of technologies that comprise such an application. For bugs that arise from the HTML and script received by the browser or in the transfer or request of a page's markup, developers often adopt archaic debugging techniques, such as using View Source and Notepad to scrutinize the contents received by the browser.

Scott Mitchell

MSDN Magazine April 2006

Cutting Edge: Moving DataGrid Rows Up and Down


Imagine opening your Inbox one morning and finding a message that reads "Dear Mr. DataGrid, I urgently need an ASP.NET DataGrid that lets my users move rows on the client. You're my last hope. Will you please help me?"

Dino Esposito

MSDN Magazine March 2005

Do not see the table in Database after moving the project folder



I created a ASP.NET project under Visual Web Developer 2008. Under that project I had a Database (along with ASPNETDB.MDF) which has about 3/4 tables (I had SQL server 2008). Everything was working fine (like insert, delete, etc.). And I was able to view the tables in database explorer view.

Then I had to format my computer for some reason and I copied the whole project in a USB drive and then after formatting the computer I copied the folder and tried to open it in Visual Web Developer (now I have VWD 2010). I can see the both Database under App_Data folder (ASPNETDB.mdf and the DB I created). ASPNETDB has all the tables and data as expected. But I do not see the tables under the DB I created.

I also tried in one of my friends computer who has Visual Web Developer 2008. But same result.

I am just wondering if anyone can help me with retreiving the table. I have a bad feeling that I might needed to do something to backup the data (not sure though). But the tables should be still there ... isn't it ?

Any help will be appreciated. Thank you in advance.

Moving a website - URL aliasing question


Hi we are migrating a website from a proprietary system  to a new system built inSQL 2008.

The old  system has about 6,000 pieces of content with individual hard-coded aliases. How could we go about creating a match table to ensure these resolve with our new system (based on Intellgentsia URL rewriter)?

Any pointers would be helpful.

Linq with two databases (oracle and sql server)


i have a problem to bring the data from the oracle (external database) and the sql server together (with similar data). The linq entities are linked to each other. The structure is like different countries with different cities and so on. To display these "non original linq objects" i need to put them into entities (linked to each other). Now i add some of them to my sql database. But for every entity i must check the connection to the other objects i don't want to add and delete them (otherwise linq will add all the connected objects, even those I don't want to add). If this goes wrong the whole input-method crashes. Is there any other possibility, except from checking every single entity and removing unwanted connections, to handle this procedure?
Thanks a lot, preg

Problems moving an InfoPath form from a DEV system to QA environment


We developed an InfoPath form using a local DEV environment.  The site collection under which the form was developed was http://server1/.

We are now attempting to deploy this form to a TEST environment that uses a slightly different structure for the collection, namely http://server2/sites/sitecol1.

In both cases the site that contains the form is /fin (so we were using http://server1/fin in DEV and want to use http://server2/sites/sitecol1/fin in TEST). 

The form contains VBA code and so requires admin-based deployment via Central Administration, so to deploy to TEST we:

1. Publish the form against the TEST server using InfoPath Designer

2. Upload the form using Central Administration > Application Managment > Manage Form Templates

3. After upload, we activate the form for the site collection http://server2/sites/sitecol1/

4. The form is then associated with a Form Library

When we try to create an instance of the form within this library we get the following error when we click on New to create the form instance:

The following location is not accessible, because it is in a differ

WSS 3.0 - problem with moving the database


My company wants to move a database included with WSS 3.0 installation to a *separate* server.
We want to have the database completely separated, on a different computer, on SQL Server 2005 installation.

Unfortunately, I'm not sure If the sharepoint is configured as a "Web Front End" or  "Stand-alone".
All I know, everything currently is on the same computer, and we can connect to the live database using the following path: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

The question is, how can we move the database to SQL Server 2005, on very different server, leaving the application untouched?

Quick summary, we currently have:

--- Server A: (WSS 3.0) + [windows internal database / SSEE (not sure!)] + DOMAIN X

and we want t
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