.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

SharePont 2003 - Move content database

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

I have been unable to use Backup Restore because the topology was unsupported.

I have successfully moved the config database.

Now I have backed up and restored the SQL database for the content db and am having trouble finding out how to attach the content database back in to sharepoint.

I normally use SP2007 but am having trouble locating the attach content db stsadm command.  It may even be possible through Central Admin.

Anyone know how this is done?

View Complete Post

More Related Resource Links

Move Single MOSS Content Database to Different SQL Server

We want to mmove the single database of MOSS on Network Test and Development to the Production SQL Server. But MOSS aplication server remains same!

So in this condition it points out for the two database servers at the same time.

Is it possible? Or I need to migrate the all concern databases to the another SQL Server?

Pls HelP!

How to get access to content database after server hardware failure


Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.

Regards, thanks for help.

Victor Naranjo MCSE + Security MCSA + Security MCSE + Messaging MCSA + Messaging ITIL Certified Comptia Security+

MOSS Content Database has more documents than what's seen on browser

I am not sure how sharepoint internally handles stuff, but this is what I see. I am a SQLDBA and one of my company sharepoint group re-organized a site, by moving some files from a document library to another document library. I think she used the content deployment.

When she see the number of documents in the document library it showed 700 documents. She moved only 50 of them. I went into the database and queried the Docs and DocStreams View and I get the list of all the those documents. I see both the ones that we see on the site as well as something that we do not see on the site.


ad.DirName, ad.LeafName, TimeCreated, ads.size/1024 as [Size(KB)], SetupPath

FROM Docs ad, DocStr

Estimate weight of BLOB data in our content database

How can I estimate overall size of blob data?

SharePoint Version 2.0 (WSS 2.0 SP3) Content Database restore to new farm

Is it possible to use an SQL backup from a sharepoint Version 2 SP3 database to restore the content on a new server farm and attach to a new web applicaiton. NOTE: This is WSS 2.0. In WSS 3.0 this is a very simple task, but it is not the same in WSS 2.0 (the add content database option CANNOT be used to attach to an existing content database like it does in WSS 3.0). The options I have found appear to say you need the configuration database from the old server then it can be done. I am migrating from an outsourced deployment, so I do not have access to that. Plan B is to do a sharepoint STSADM backup. THis seems to be a more likey way to do it.

Cannot create content database: The specified SPConfigurationDatabase Name=SharePoint_Config Parent=

Guys, This is the farm configuration: 1. SQL Server 2005 back end server 2. WSS 3.0 / MOSS 2007 WFE Server 3. WSS 3.0 / MOSS 2007 Index/WFE Server All servers are showing the version: in 'Servers in Farm' in C.A. When attempting to add a new content database, the following error is thrown in the web UI: The specified SPConfigurationDatabase Name=SharePoint_Config-New Parent=SPDatabaseServiceInstance has been upgraded to a newer version of SharePoint. Please upgrade this SharePoint application server before attempting to access this object. Furthermore the following is posted to the application event log on the WFE hosting central admin: Database 'SharePoint_Config-New' on SQL Server instance 'XXXXXXXX' is not empty and does not match current database schema. There is nothing of further interest in the trace log, just the same error as above. No errors on the SQL server either. Also no updates have been installed, and content databases HAVE been created since the last updates were installed 2 years ago. Can anyone suggest anything before I raise a call with MS? I have checked permissions for the sharepoint system account on the databases and all seems fine. Cheers, Conrad    Conrad Goodman MCITP SA / MCTS: WSS3.0 + MOSS2007

Database Table: Move row to the top of the table???

I have a table in my aspnet database.  I added a bottom row "Not Selected", if the user doesn't select from a databound drop down list.  This row is at the bottom, because I just added it to the table data.  Is there any way to move this one row to the top of the table manually?  There is not "cut" and "paste" when I select the whole row.Any idea how to do this?  Thanks in advance. :)

How to get previous version of content database

Hi,   Setps I did.... 1. Created Site collection with url http://server.80/Site1 2. taken the back up of dev server site collection and trying to restore with this new site collection 3. But, i restored in http://server.80/ How to get the content databse back up of http://server.80/  Pls its very urgent......................   Thanks in Adv..................

Content Database Purge ?

  I just made an experiment: created new web app created new site collection put there a doclib1 with 5 Gb of pdf documents checked size of content db in sql studio - it was 5.5 Gb with 300 Mb available (free, but reserved space, that can be redeemed with shrink operation) Then i deleted doclib1 Then i cleaned recycle bin (2 level), so on this stage the data is totally deleted on site level with no restoration options Checked the db - 5.5 Gb (which is normal) with 800 Mb available. Why 800 Mb and not 5 Gb ? Why i can redeem only 500 Mb in the end ? Are sharepoint content dbs are even made for redeeming space after some of its contents are deleted ?

after restoring content database getting error (HTTP/1.1 200 OK Server: Microsoft-IIS/7.5 Date: Tue,

Hi All, Problem i have taken backup of Old site content database procedure see below 1) first i changed the database to read only mode (Opened SQL Server2005-->selected DB--> properties--> Option-->Database Read-Only=True) 2) taken backup of database from the task--Backup(new.bak) 3) Copied the taken backup to new server and restored (Opened SQL Server2005 --> Right Click on Database Folder--> Restore Dataase) In To database: ihave given DB name From Device: i have selected database from the location where i have saved. click ok.  It has restored successfully 4) I have created a new webapplication and removed its content database from central admin. 5) with the help of stsadm command i restored the above db to this webapplication. then iam getting below error: HTTP/1.1 404 Connection: close Date: Tue, 14 Sep 2010 06:20:08 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET MicrosoftSharePointTeamServices: i have refered the below url for restoring http://metahat.blogspot.com/2008/11/backup-restoring-sharepoint-2007-site.html Please help. Thanks in advance.

Database design for treeview and content

HiI"m student and need help to design a database for treeview and some content.I need a database design with treeview and it's childnodes,  different content for each node, and modules for each page, like search, contact form and etc... with ability to turn it on and off.Maybe you can show me the way or maybe you have some good links for database design. Any help would be appreciated.THANKS

Powerhsell script for MOSS 2007 to get content database size



Can you please provide me a script to get content database size in MOSS 2007.




After adding the content database, i could see the Current Number of Sites are zero.


After adding the content database, i could see the Current Number of Sites are zero.

Its should be 5, but its hsowing me 0,

what i need to do for this 

Crawling does not happing on a content database from set of DBs of my Web Application (MOSS)


Hi Team,

This is regarding indexing in MOSS content sources. I have an MOSS application(web site) configured as Content source for crawling. A user reported that his is not able to search on the content uploaded to his site. After performing quite a few checks and investigatations. We found below info in crawl log, we suspect that this is  crawling of all sites in Content Database(i.e., non are crawled and searchable). Atleast that is what we understand by trying search of quite a few sites residing in the databse.

Exception from HRESULT: 0x81070504 (There is no Web named "/sites/020045t".)

Also we find the site only in SiteMap table in SharePoint config Database only. We tried deletesite command with -force and -siteid switch, both were unsuccessful. Can someone tell us how to remove this orphan site/ entry in sitemap table? We are hesitent to delete the row in sitemap table since we do not impact of doing it from backend.

Thank you,


how to insert data into database from content page?


Please help me to insert data to database from a content page of a master page. My code is working fine when i use my code without master page but with content page of master page i dnt knw what goes wrong. Help me on this please.

thank you

move infopath forms from SP Portal Server 2003 to 2007


I am a newbie to SharePoint. Please let me know if I didn't explain my problem well...

We built the new SharePoint server 2007 on a different physcial box from the old server 2003. There are huge amount of InfoPath forms in form library on the old server. I was told that: to get these forms moved over to the new server 2007, we have to save the forms and re-publish to the new server one at a time. This will be really time consume and also loosing the attributes of the original forms, the date it was created and modified etc.

I would like to see if there is a way to move one form library at a time, and just copy the forms over; not publishing them again.

Many thanks!


Move page in Site Content and Structure alters revision history and makes old content available


This sounds bizzare, I tried it on an OOTB publishing site.

I have a page X in site A. Page X has version 1.0 and 2.0 approved and published, no minor versions anywhere. I choose to move page X to site B. Page X now has revision history version 1.0 (published and available) and version 1.1, which is exactly the same as version 2.0 but no longer visible to the outside world.

So the first problem is that moving a page makes a previously published and overwritten version of the page content available again. If I publish the page it goes to version 2.0, but I have to remember to do this. Also because I approve the page, my user id is associated with the publication of the content (which is sorta ok) but the original author of version 2.0 has now presumably been lost to the ether ... or the green swirling icon of death.

But I don't publish page X because I think "oops I meant to move page Y" and move it back to site A, without first publishing version 1.1. Now I have version 0.1 and 0.2. 0.1 matches the original version 1.0, and version 0.2 matches the original version 2.0, however the best bit is that the timestamps are such that version 0.1 is now checked in after version 0.2.

I then publish the page, I now have version 0.1 and 1.0, where 0.1 matches the original version

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