Content Database would not attach to MOSS 2007

Every time I attached Content Database to web application it deleted the stored procedures and failed with the following error in the log file:

[SPManager] [ERROR] : Cannot find the object "DatabaseInformation" because it does not exist or you do not have permissions.

I researched a lot of the posts out there and they were all dealing with upgrade uissues. The problem was this was not an upgrade this was the same database attached one day ago. After trying to to move a site off it and it failed so I tried to reattach it to get the site out the backup and it kept failing!

I tried using tools like DocAve and Metalogix to move data and/or site off it but they also failed.

Finally, I attached a clean db to the portal “New_DB”. Then I renamed the corrupted database to New DB.
It was now attached to the web application however it has 0 sites!
So I created a site on it called test
I then tracked down the ID for the corrupted site and the new test site from Corrupted Database Now “new_DB”
SELECT [Id]
,[SiteId]
,[FullUrl]
FROM [New_DB].[dbo].[Webs]

Once I the ids they look like this corrupted(887E0ED3-9CDD-42EC-8A38-6D397349169B)
new test site (0477CF53-F1C0-4CDD-9FDF-D1F61A10DE8A)
I went into the SharePoint_config db
WARNING: this is very dangerous make sure you backup the db and copy tables before altering.

I looked for the new test site I created
SELECT
*
FROM [SharePoint_Config].[dbo].[SiteMap]
where id ='0477CF53-F1C0-4CDD-9FDF-D1F61A10DE8A'
I grabbed the ApplicationId something like this '3B988D4F-4AD6-40F1-B7A8-8A4EBA9FC12D'

Now I ran an update statement to set the path and id for the new site (test) to the path and id of the corrupted site

update [SharePoint_Config].[dbo].[SiteMap]
set path= '/sites/oldsite'
where ApplicationId=
'3B988D4F-4AD6-40F1-B7A8-8A4EBA9FC12D'
and id='0477CF53-F1C0-4CDD-9FDF-D1F61A10DE8A'

update [SharePoint_Config].[dbo].[SiteMap]
set id= '887E0ED3-9CDD-42EC-8A38-6D397349169B’
where ApplicationId=
'3B988D4F-4AD6-40F1-B7A8-8A4EBA9FC12D'
and id='0477CF53-F1C0-4CDD-9FDF-D1F61A10DE8A'

And Voila just like that the site was up.
Now I was able to move the data I needed and everyone is happy:-)

Get ID for a SharePoint 2007 Database

One easy way of figuring out the ID of your SharePoint 2007 db is to mouse over the content database in central Admin/ Application Management
Copy the shortcut for the link
Paste it and look at the string do not worry about the first two characters

Moving a Site to another content database in SharePoint 2007

First you have to generate xml file that contains information about sites and content dbs.

Use this command

stsadm -o enumsites -url http://websername >C:\sites.xml

to create sites.xml

Clean it up and only leave site you want to move

Rename to move.xml to only have info about the site you want to move

Now run this command

stsadm -o mergecontentdbs -url http://websername /sites/sitename -sourcedatabasename Old_Content -destinationdatabasename New_Content operation 3 -filename C:\move.xml

Cannot Add Content DB to MOSS 2007 after SP2

Cannot Add Content DB to MOSS 2007 after SP2
Through Central Administration:
you receive this error
Method not found: 'Microsoft.SharePoint.Administration.SPContentDatabase Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(System.String, System.String, System.String, System.String, Int32, Int32, Int32, Boolean, Boolean)'.

Resolution:
Use stsadm to add content db
C:
cd C:\Program Files

cd Common Files

cd Microsoft Shared

cd web server extensions

cd 12

cd bin



stsadm -o addcontentdb -url http://BENNA0SHRPT2:7777 -clearchangelog -databaseserver Severname -databasename NewDBName

"Auto F5 reload window" options
Default timeout	*
Timeout for this page	*
Add random value to timeout between 0 and	*
Show and hide menu
Ignore everything after these symbols in URL(separate with spaces)
Include the separators in the URL saved
Hide menu when clicking outside the menu
Prolong timeout on mouseclicks or keyboard input
Reload all pages with default timeout, which has no timeout set
*Format examples: hh:mm:ss, h:m:ss, m:sss, s etc. like 1:20:30 oder 500 oder 3:100

The evaluation version of Microsoft Office SharePoint Server 2007 for this server has expired

We were getting this error when users were tryng to access their my sites and search!

i tried to resolve the error by doing what Joel Olson suggested here
http://blogs.msdn.com/joelo/archive/2008/01/02/evaluation-version-expired-but-not-really.aspx

However that did not work.

Finally our Sharepoint Admin Jessi marx found this article on Microsoft's site
http://support.microsoft.com/kb/971620

I reapplied the Product Key and everything worked Again!

"Auto F5 reload window" options
Default timeout	*
Timeout for this page	*
Add random value to timeout between 0 and	*
Show and hide menu
Ignore everything after these symbols in URL(separate with spaces)
Include the separators in the URL saved
Hide menu when clicking outside the menu
Prolong timeout on mouseclicks or keyboard input
Reload all pages with default timeout, which has no timeout set
*Format examples: hh:mm:ss, h:m:ss, m:sss, s etc. like 1:20:30 oder 500 oder 3:100

Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))

You get this Error when you load some SharePoint 2007 Sites
Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))

We were only getting this error on specific sites. We found that all these sites resided in the same content db.

After some investigation we found that some of the Stored Procedures in that db were missing.
We restored the latest version of the content db and everything worked fine!

Thank God for backups! LOL

"Auto F5 reload window" options
Default timeout	*
Timeout for this page	*
Add random value to timeout between 0 and	*
Show and hide menu
Ignore everything after these symbols in URL(separate with spaces)
Include the separators in the URL saved
Hide menu when clicking outside the menu
Prolong timeout on mouseclicks or keyboard input
Reload all pages with default timeout, which has no timeout set
*Format examples: hh:mm:ss, h:m:ss, m:sss, s etc. like 1:20:30 oder 500 oder 3:100

"Auto F5 reload window" options
Default timeout	*
Timeout for this page	*
Add random value to timeout between 0 and	*
Show and hide menu
Ignore everything after these symbols in URL(separate with spaces)
Include the separators in the URL saved
Hide menu when clicking outside the menu
Prolong timeout on mouseclicks or keyboard input
Reload all pages with default timeout, which has no timeout set
*Format examples: hh:mm:ss, h:m:ss, m:sss, s etc. like 1:20:30 oder 500 oder 3:100

Lost connection to site. Page will be reloaded, when the connection is restored...

MOSS Search not working on site level

After adding another URL to access MOSS portal search stopped working completely.

you could access the portal through two URLs
A secure
https://portalname
and another url
http://portalname:7777

For some reason the https crawls were failing and I fixed that by editing contenet source to crawl this
http://portalname:7777 instead of https
This fixed s MOSS search on Portal level but did not work on top level sites.
After doing some research I was able to fix SharePoint search on site level by configuring Alternate Access Mappings and making this http://portalname:7777 instead the default