.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 Single MOSS Content Database to Different SQL Server

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :SharePoint
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!

View Complete Post

More Related Resource Links

How to Backup Single Server (Database on same server )Extra-net SharePoint Site MOSS 2007 SP1? and H



I have to create Test Server (Single server with Database on Same Server).

What Kind of Backup should i be asking  to Hosting Company,SharePoint MOSS 2007 SP1 Extra net site Hosted by 3rd Party.

How to restore it to Test Server and Has any one documented this process and has anyone had sucess in doing similar work ?

I do not have any access to Production server.How to make sure i have same server setup & configuration as Production Server.


I have to customize this site and do some development work so i thought this would be best approach ?


Please let me know..thanks..



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

SharePoint 2010 Server: Cannot manage all user profiles from upgraded MOSS SSP database

I have upgraded an SSP database to SharePoint 2010 and successfully performed User Profile Synchronization with Active Directory, however I cannot manage ALL of the user profiles in the database. I go to "Manage User Profiles" in Central Administration and perform a filtered search (i.e. I want all DOMAIN accounts beginning with "j" so I search for "DOMAIN\j" in Manage User Profiles), but I don't receive ALL the user profiles back. I receive about 8 in return when I know there are about 20 starting with "j". If I create a new AD account beginning with "j" it is successfully synched with SharePoint 2010 and I see it in the Manage User Profiles. I ran an stsadm -o sync to clear any old synchronization information, and the Forefront Synchronization Service appeared to pull in many changes to existing accounts (including ones I can't currently manage), but I still cannot manage them using "Manage User Profiles". I really need to be able to manage all the profiles so I can manually edit some fields. Can anyone please help? Thanks in advance.

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.

Scaling Single Server Farm by adding a seperate Database server

Hi, Right now, I am having a sinle server farm SharePoint 2010 installation. Now I need to seperate out the SQL server from the same box and want to move it to the new SQL server. In short , I need to have a seperate SQL server in my current farm (which is single server farm installtion). Can some one point me to the steps for the same ? 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.




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,


Move Configuration Database to a different server



When installing Sharepoint, I accidentally selected to install it as a SQLEXPESS server located at ComputerName\Sharepoint and didn't notice. When my site hit the 4 gig limit, I moved the content database to another server quite easily.


Now I'm wondering if it is best practice to make sure that everything is on the same server. Poking around in Central Administration I notice quite a few references to the Sharepoint server, and then my Content Database which is off on it's own. Is there an easy way to migrate everything over to my new server (a cursory glance around google hasn't turned up anything yet) or should I leave it fragmented as it is?




Unable to connect to the SQL content database from sharepoint web front server.



SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.

SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10 to 15 min.

when ever these errors occur in eventvwr sharepoint will not work.

Please suggest on this issue.

waiting for MS replies..






Restoring content database to another server

I am using sharepoint server 2007,I took a backup of content database and want to restore it to the content databse to another server,without creating a new web application,how can i do this

SharePont 2003 - Move content database


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?


I am a bignner in DATABASE TECHNOLOGY,I have a Remote server for my web site on which I have database and I want to change my Database Server and I want to move My all the Database from one  remote Serever to another remote server..Please help me as soon as possible ..

Migrating MOSS 2007 installation from one database server to another - configuration database issue


The database server which our sharepoint installation is currently using is going to be shutdown and a new one is going to be put in production.

I read in some post that the configuration database cannot be moved (while the same operation type is documented for content database). Is this correct?

Isn't there a way by which I can modify my current moss installation to define the use of another sql server for configuration (and then later for content) databases?

Any other workaround or procedure?

Thank you!


Restoring a content database from another server/AD does not synch user profile information for new


In my SharePoint 2010 beta environment, I have user profiles synching with Active Directory.  I just restored a content database from a separate environment/domain and logged in with my current account.  When I try to create an alert on a library/item, I get the error:

“You do not have an e-mail address.  Alert has been created successfully but you will not receive notifications until valid e-mail or mobile address has been provided in your profile.”

I went to My Profile and found that the My Profile had the right e-mail address (I guess because this is on my My Site Host).

But when I went to My Settings, it did not have any e-mail address for me (I guess this is because it is at the WSS content database level and the e-mail address hasn’t yet synched from the user profile database).

Does anyone the timer job that synchs the user profile with the My Settings for a site collection in a content database?

Issue is posted to my blog with screenshots here:



Max files in a single WSS 3.0 Database (SBS 2008 Server - Window Internal DB)


This site appears to indicate that the max documents per database is 32,767 :


This seems extremely small to me. Is that an accurate number? We have a customer with 300,000 documents and about 30 users. Is this going to be too much for a single DB?

SQL Server 2000 Database in "single user mode"


Hi all,

I've an old production database server with SQL Server 2000 SP4, that runs from 6 years. Now sometimes I find that the production database goes in "single user mode". Why? My error logs don't help me.

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