Is it possible to change the content database of an existing SharePoint '07 web app?

Posted by mcjabberz on Server Fault See other posts from Server Fault or by mcjabberz
Published on 2011-08-03T15:26:33Z Indexed on 2012/09/12 3:40 UTC
Read the original article Hit count: 674

Filed under:

sharepoint

|

sharepoint-2007

Disclaimer: I'm very much an accidental SharePoint admin so I greatly appreciate your patience.

My SharePoint farm's database server is EOL and about to die. I have managed to get the config database (SharePoint_Config) moved over to the new database server and even managed to get the Central Administration site to use the new database server. I have even added the new database server to the farm as a content database server. My problem right now is with the web app's content database (WSS_Content). I already have a copy of the content database setup and ready to go on the new database server but, for the life of me, I can't figure out how to change the SharePoint web app's database over to it.

Is this even possible? If so, how would I do it? If not, would I have to create a new web app and then restore (and overwrite) its WSS_Content database with my existing one?

© Server Fault or respective owner

Related posts about sharepoint

SharePoint 2010 MSDN Labs

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Eric Ligman, from Microsoft, posted a great blog post this week listing all of the SharePoint 2010 Virtual Labs that are available from Microsoft. His blog entry is here: http://blogs.msdn.com/b/mssmallbiz/archive/2012/03/13/sharepoint-server-2010-msdn-virtual-labs-available-to-you-online-plus-more-sharepoint-2010-resources… >>> More
Enterprise SharePoint 2010 Hosting, SharePoint Foundation 2010 Hosting, SharePoint Standard 2010 Hos

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Enterprise SharePoint 2010 Hosting, SharePoint Foundation 2010 Hosting, SharePoint Standard 2010 Hosting, Michigan Sclera, a Microsoft Hosted Services Provider Partner, is offering key Service Offerings around the Microsoft SharePoint Server 2010 stack. Specifically – if you’re looking for SharePoint… >>> More
SharePoint Personalization Site Links - Les liens personnalis?s des MySite SharePoint

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Nous avons vu dans les articles pr?c?dents comment agr?menter les pages de recherche afin de permettre une meilleure adoption du produit par les utilisateurs. Il existe une autre fonctionnalit? de Microsoft Office SharePoint Server 2007 (MOSS) qui permet aussi de personnaliser un peu le MySite des… >>> More
Auditer une ferme SharePoint - Assurer le bon fonctionnement de SharePoint

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Dans le cadre de la bonne gestion de son environnement SharePoint, il est utile de faire un contr?le de son installation afin d'assurer le bon fonctionnement des fermes et donc, la meilleure disponibilit? pour les usagers. Dans ce but, nous verrons comment auditer sa ferme facilement et les traitements… >>> More
Using jQuery and SPServices to Display List Items

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I had an interesting challenge recently that I turned to Marc Anderson’s wonderful SPServices project for. If you haven’t already seen or used SPServices, please do. It’s a jQuery library that does primarily two things. First, it wraps up all of the SharePoint web services in a nice little AJAX wrapper… >>> More

Related posts about sharepoint-2007

Les alertes dans SharePoint 2007 - Comment SharePoint 2007 g?re les User Alerts

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Une des fonctionnalit?s de base de SharePoint, aussi bien dans Windows SharePoint Services (WSS) que dans Microsoft Office SharePoint Server (MOSS), est la capacit? de d?finir des alertes. Nous verrons donc dans cet article ce qu'est une alerte, comment cela fonctionne plus en d?tail et comment effectuer… >>> More
RSS Comment Feeds from SharePoint 2007 Blog

as seen on Super User - Search for 'Super User'
Is there any way to subscribe to RSS comment feeds from a SharePoint 2007 blog? Or to include comments in the standard RSS feed? Some easy way to be notified or new comments to a thread via RSS? >>> More
SharePoint 2007 - Current Timer jobs?

as seen on Stack Overflow - Search for 'Stack Overflow'
How to find the currently running SharePoint 2007 Timer jobs using STSADM? >>> More
The relative effort of SharePoint 2010 vs. 2007

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
SharePoint 2007 was the best demo-ware ever. It’s like going to the pet store and seeing a great dog that does backflips all kinds of tricks – and it really is a smart dog and it does all those tricks – but when you get it home you realize that what you need is a dog that gets the paper. SharePoint… >>> More
SharePoint 2010 Workflow for Multiple Items (Architecture)

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I had the question today of whether SharePoint 2010 supports workflow on multiple items, since Groove's workflow apparently supported multiple items and that model disappeared when Groove Workspaces were amalgamated into SharePoint Sites and SharePoint Workspace (the client utility). It's a great… >>> More