.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

Move Sharepoint DB

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


I have installed typical / basic installion of Sharepoint 3.0 and it looks like the content db is created locally in the machine and is not accessible from SSMS from any of the network machines.

How can I move this existing db to our normal sql server box without reinstallment process?


View Complete Post

More Related Resource Links

what is the best way to move a wss 3 list to Sharepoint 2010 server?

what is the best way to move a wss 3 list to Sharepoint 2010 server? (note, the wss3 is a hosted sharepoint so we don't have access to the server o/s) tx!  ==GP Blog== http://dynamicssmallbusiness.blogspot.com/ ==Free GP Addons/Customizations/Tips== http://landiscomputer.com/offer/1010_GP_Newsletter.htm ==GP Tweets== http://twitter.com/search?q=%23dyngp#search?q=%23dyngp

Move Sharepoint Search Administration Component

I am failing to transfer the Sharepoint Search Administration component from one Application Server to another. Using the -Force parameter generates the same result. The $admin and $searchInstance are valid objects. Seems a bit chicken and egg. I am trying to move the web service and the complaint is that the web service is not on the server! PS C:\Users\sp2010setup> $admin | Set-SPEnterpriseSearchAdministrationComponent -SearchServiceInstance $searchInstance Set-SPEnterpriseSearchAdministrationComponent : SharePoint Server Search Admin Web Service is not started on server FOOBARSAS2. Please start it and try ag ain. At line:1 char:55 + $admin | Set-SPEnterpriseSearchAdministrationComponent <<<<  -SearchServiceIn stance $searchInstance     + CategoryInfo          : InvalidData: (Microsoft.Offic...rationComponent:    SetSearchAdministrationComponent) [Set-SPEnterpris...rationComponent], Inv   alidOperationException     + FullyQualifiedErrorId : Microsoft.Office.Server.Search.Cmdlet.SetSearchA    dministrationComponent

Migrate/Move Document Library from Sharepoint 2007 to Sharepoint 2010

Hi, I have a customer that is setting up a new SPS 2010 environment. They have a Sharepint 2007 environment with one document library containing only PDF files. They will not need any metadata on these documents, but would like it to be moved to the new SPS 2010 environment only to be used for history and free text search. Is there an easy way to accomplish this?   Regards Christian GrannesChristianLLoyd

Move SharePoint 2010 Server/Services

I currently have a SharePoint 2010 Enterprise server running as a virtual machine.  I want to move this to a physical server that has more power to handle the load I've been throwing at it.  What is the best approach to take to accomplish this.  Ultimately, the current server will be completely gone when this is complete.  I am using shared services with a "MySite" configuration as well as the SharePoint Enterprise Search. I think I tried this when I was running MOSS 2007 and things didn't go so well, even though I backed out the original server properly, central admin still thought it had to go to the original server. I really need to move this bad.Dave Durand

Move SharePoint 2007 on Windows 2003 32-bit to Windows 2008 64-bit


I am planning to move SharePoint 2007 from a Windows 2003 32-bit system to a new Windows 2008 R2 64-bit server tomorrow afternoon.  I have done much research and found only one article that gives me enough information to go on for the migration.  Others in technet have cited this article; so, I expect it is the one go use.  However, before I begin, I wanted to see if anyone has anything else to add. 

Here's the article I'm planning to use:


Our current environment consist of one front end server (Windows 2003 32-bit running MOSS 2007) and one SQL server (Windows 2008 Standard 64-bit with SQL 2008 640bit).  So, we don't need to move the SQL databases - just the SharePoint front end.  We are moving to Windows 2008 R2 with MOSS 2007 (same SP and patch levels are planned).  

Our final goal is to move to SharePoint 2010 in the next week or two, but this seems to be the required first step.

Most of what I've read online contradicts other things.  I've found no consistency between articles.  

Thank you in advance for your assistance. 

Move a file from a Document Library to a location on a server not in the SharePoint Farm

I have an excel file I need to move daily from it's location in a MOSS enterprise edition Farm, to a location on a SQL server not in the farm but in the same domain. Is there some method I can use using OOB SharePoint or OOB SharePoint w/SPD?

copy / move pdf file in documents library sharepoint 2010



I have a document library that contains many folders with different documents.

The library contains various content types.

When I try to copy or move a pdf document from folder to another  folder. the pdf document is copied, but without his meta-data.
 and the content type the file becomes to  default content type of system, to  "document."

Copying is done by explorer window
 (ie the documents library open the document library explorer Explorer And where we do copying or moving documents .)

It should be noted that when doing "copy to" or "move to" of documents and type Microsoft Office the meta- data yes  copied properly.

The problem applies only to the pdf files.

How do I make a copy or move of the pdf document with his meta-data  by explorer window?

Move SharePoint Document Library Files to Local Drive

How can I move files uploaded into a MOSS 2007 Document library to a local drive? I need to automate this as a job, not a one-time process. Can I use SSIS for it? File Systems Task works fine so long as I create a map drive to the portal. I have tried both the http address and the UNC path to the portal.

sharepoint security groups, ACL of site collection or subsite need to move in to sql server 2008 usi


HI Team,

I am new to sharepoint here is my query. i am working on MOSS 2007, SQL server 2008

I want to move the sharepoint security groups, ACL(access control list), user groups all the security and permission related data to sql server 2008 from a particular site collection or subsite. After getting the data in to sql server we should be able to update the users from sql server itself which should reflect in sharepoint sites.

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?

Move a sharepoint list in sharepoint 2007 to sharepoint 2010

i have a list on a sharepoint 2007 site and i want to move it to a sharepoint 2010 site. my problem is the items have files attached to them. what would be the best method to do this.

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?



How to make editable row move to top of SharePoint List?


1. By default the editable new row is at the bottom. I want to move that to the top. I am using SharePoint Server 2007.


Ravi Acharya

Move SharePoint-2007 Database.



I have sharepoint-2007 farm we are using sql server 2005 as databse, now we are plning to migrate our sql server from 2005 to 2008, new sql server will have different name, so can any one let me know which would be the easyest way for me to redirect the farm to reference the new databse server.

our DBA is going to create SQL server connection alias.

bhaumik patel

Changing the graphics on the home page of a SharePoint site

When you create a site in Microsoft Windows SharePoint Services by using the default Team Site template, the home page includes two default graphics. A Windows SharePoint Services graphic appears in the body of the page, and a picture of a house in a circle appears near the site title. You can change these graphics to customize your site. Changing the smaller graphic requires a Windows SharePoint Services compatible Web page editor

Displaying SharePoint lists in Web Parts

When you create a built-in or custom list in Microsoft Windows SharePoint Services, Windows SharePoint Services creates a Web Part, a basic building block of a SharePoint site, to display that list. These Web Parts are called List View Web Parts. Windows SharePoint Services stores List View Web Parts in the site collection Web Part gallery. (The site collection Web Part gallery is the most central gallery of Web Parts for a work group. By default, the gallery name is the name of the site, such as "Our Team Site Web Part Gallery." )

Take a tour of your SharePoint site

What is a SharePoint site for?
A SharePoint site is a Web site that provides a central storage and collaboration space for documents, information, and ideas. A SharePoint site is a tool for collaboration, just like a telephone is a tool for communication, or a meeting is a tool for decision making. A SharePoint site helps groups of people (whether work teams or social groups) share information and work together. For example, a SharePoint site can help you:

Coordinate projects, calendars, and schedules.
Discuss ideas and review documents or proposals.
Share information and keep in touch with other people.
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