.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

One WFE still pointing to content db from OLD server

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


I have this issue, yesterday we moved couple of content db from one db server to the 2nd server due to disk space.

we detach them from share-point(CA) then DBA move them to new server and set the permission. Now we attached the content Db sucessfully.

everything seems to work fine but no.

One WFE trying to connect the content db on old server(from where we move them) but other one is updated and rendering the site correctly


could you please help me why one WFE is trying to see the content db on old server. 

we get the unknow error in the browser and in the ULS logs its clearly writing that loging failed for the contentdb on old server while all content dbs are on new server.


any help appreciated.



SharePoint administrator, MCTS,MCITP

View Complete Post

More Related Resource Links

SQL Server: Build Apps that Provide Real-Time Information and Customized Content Using SQL Server No


The adoption of wireless devices continues to spread unabated, and organizations are looking for new ways to get in touch with customers through these new mobile devices. In the past, unsuccessful ideas such as push technology were used to send targeted information to customers. Now, SQL Server Notification Services uses the SQL Server 2000 database engine and the .NET Framework to promote a new breed of notification applications that will allow relevant, consensual communications to be sent to any subscriber device.Here the author provides an architectural overview of the core features that make up SQL Server Notification Services. Along the way he discusses how they can be used for pushing Web content.

Mark Brown

MSDN Magazine November 2002

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+

"Content for this URL is excluded by the server because a no-index attribute." in crawl logs


Hi All,

I am getting following error message in Crawl Logs

" Content for this URL is excluded by the server because a no-index attribute. "

Any help in this regard will be greatly appreciated.



Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Customizing the Content Query Web Part in SharePoint Server 2007

Walk through how to customize the Content Query Web Part in SharePoint Server 2007 to query content across multiple sites in a site collection and display the results in any way that XSL can support. Learn how to get similar results when customizing the CQWP does not meet your needs.

Best Practices for Content Types in SharePoint Server 2007 and Windows SharePoint Services 3.0

Learn best practices to develop, deploy, and manage custom content types, as well as scenarios for making updates to existing content types in lists.

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.

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!

Is there a way to show xHTML content in a SQL Server Reporting services?

Is there a way to show HTML content (in a table column) in a SQL Server Reporting services ?

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

Content Deployment From One domain server to another Domain Server



I am trying to deploy the content from one server to another server(Both servers are in different domains).

Is it possible to do it with MOSS 2007 Out-Of-The-Box functionality(Content Deployment).

Is yes, Kindly explain the steps to be done.

When i tried to deploy content while running the job, "Content deployment job 'Remote import job for job with sourceID = b29a2099-8741-409e-89d2-8b8e95abe833' failed.The exception thrown was 'System.IO.IOException' : 'The process cannot access the file 'Manifest.xml' because it is being used by another process.'". This error occurs when i tries to deploy the contents from 32-Bit server to 64-Bit Server(Both are in different domains).

Kindly provide your suggestion.

Thanks in Advance,


“Changing the Face” can change nothing.But “Facing the Change” can change everything.

Content for this URL is excluded by the server because a no-index attribute.



Can't seem to find where this attribute is set:


Content for this URL is excluded by the server because a no-index attribute.


This is the warning in the crawl log for an entire subsite.



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:



Content Query web part does not render on one of the front end server


I have 2 front end servers, and always develop by pointing SharePoint Designer to server one. When I try to browse the pages on server 2, I find that none of the content query web parts render. Instead they show the following message.

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

When I open the page in designer, it says that I can edit only the page layout and not the actual page.
Any suggestions on resolving this error message?

Executing XML query from SQL 2005 pointing to SQL 2000 server

Occurs with root command.
Executed as user: DOMAIN\SERVER01. Error Code: 0  Error Source= ADODB.Command  Error Description: Item cannot be found in the collection corresponding to the requested name or ordinal.    Error on Line 18.  The step failed.
Executed as user: DOMAIN\SERVER01. Error Code: 0  Error Source= Microsoft OLE DB Provider for SQL Server  Error Description: Line 1: Incorrect syntax near 'ROOT'.    Error on Line 20.  The step failed.
Dim oCmd, sSQL, oDom
   Set oDom = CreateObject("Microsoft.XMLDOM")
   Set oCmd = CreateObject("ADODB.Command")
  oCmd.ActiveConnection ="Driver={SQL Native Client};Database=Validation;Server=server1;Uid=sa;Pwd=;"
   sSQL = "<?xml version=""1.0"" ?>"
   sSQL = sSQL &

MySite crawling warning 'Content for this url is excluded by the server because a no-index attribut


Hi Team,

We have SharePoint farm consisting of 2 WFEs, 1 Application Server and SQL Cluster having 2 nodes.  We are are seeing many of the below warnings in the MySite crawling, more importantly we do not see many of document/s and personal blog not being picked up by the crawler and nothing is searchable. We do not have any Crawl rule on mysite url nor scope rule that points to personal site URL

Can some one help me with finding the reason/cause and solution if any one has come out of this situation.

Advance thank you.


Ramakrishna Pulipati SharePoint Consultant Bangalore, INDIA
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