.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

Database attach upgrade sharepoint 2010 - Help????

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint

I am trying to migrate data from SharePoint 2007 to SP2010 Foundation using database attach upgrade Method.


I am able to Restore and Mount Database on SharePoint 2010, But Now how do I use that?

I have these questions?

1. Can do I use the restored/Mounted DB for a particular Site Collection? If yes, How?

Mount-SPContentDatabase -Name <DatabaseName> -DatabaseServer <ServerName> -WebApplication <URL> [-Updateuserexperience]

2. I have used above command to Mount the DB, but now how do I actually access the Web pages? what URL do I use?


Kindly Help...


View Complete Post

More Related Resource Links

Cannot crawl sharepoint site and mysite after database attach upgrade form sharepoint 2007 to 2010.

After database attach upgrade site and mysite from sharepoint 2007 to 2010 , I have full crawl and get "The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly. If the repository was temporarily unavailable, an incremental crawl will fix this error. ( Error from SharePoint site: HttpStatusCode ServiceUnavailable The request failed with HTTP status 503: Service Unavailable. )" for mysite and get "Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled." for sharepoint site. The content access account for search is "db_owner" of both of site and mysite. How do I solved this problem ?

Upgrade 2007-2010 Database Attach


Hi all,

Having read many of the articles abot upgrading 2007-2010, I wanted to see if a simple approach would work.

  1. Ran the pre-upgrade checker
  2. Simply detached the DB in SQL (SQL Manager only), forcing the connections to close
  3. Copied the DB to the new server
  4. Re-attached the original DB to the 2007 server
  5. Attached the copied DB to the 2010 box
  6. Ran the shell command to attach to a web application
  • All seems to work

The content databases in question are quite simple and test units, and we are moving from the staging server to production, is this a valid approach?

Also, before I try wih a 'real' db, is there any harm done in detaching/re-attaching on the original 2007 server?




it team workspace error after database upgrade sharepoint 2010


Dear Experts

i have done the upgrade for my Sharepoint 2007 to sharepoint 2010 by Database upgrade.


and i am facing only one problem with the IT team workspace template site which is as follows


[STSADM] [SPContentDatabaseSequence] [WARNING] [10/21/2010 10:31:22 AM]: WebPart class [1f221ac3-a0fb-7f40-62ac-4d83b23d41c2] is referenced [20] times in the database [WSS_Content_database], but is not installed on the current farm. Please install any feature/solution which contains this web part.

[STSADM] [SPSiteWssSequence2] [INFO] [10/21/2010 10:47:12 AM]: SPSite Url=http://ex.domainname.com/division/IT
[STSADM] [SPSiteWssSequence2] [WARNING] [10/21/2010 10:47:12 AM]: Feature could not be upgraded. Exception: Feature definition id '75a0fea7-c285-4c09-839e-0b5e1453e387' could not be found.

An unexpected error has occurred.

Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contac

attach access database in SharePoint 2010 service application


I am planing to publish Access database MyDB into Access Service application in SharePoint 2010 server farm. MyDB has following tables,

tblShared1, tblShared2, tblShared3, tblShared4, ... 

Is that possible for each user to open an Access database locally and set linked tables above in MyDB Access database? If yes, how it works?

Thanks in advance,    

SharePoint 2007 Upgrade to 2010 and the SSP database (woops)


OK everyone, I got myself a little stuck on something. We upgraded SP 2007 to 2010 in test, planned the production upgrade and upgraded production using the database attach approach, everything went pretty well except...

Users complained pretty quickly that their 'My Links' were missing and that the profile information they had previousely entered was gone... hmmm... we didn't actually check that stuff during testing, oops.

Well looking at the documentation I 'quickly' realized I had missed a step during the upgrade, both in test and prod; I never upgraded the SSP database. I created a new profile service, synch'd with AD, managed meta data service is working, upgraded the mysite content databases and bam, everything was good, or maybe not so good because I'm missing profile information that was manually entered by users.

So of course all the documentation says you need to attach that SSP database during the creation of the Profile Service, well I'm not recreating my profile service... no way. Is it to late to upgrade the SSP database? Do my users just need to start with fresh profiles and suck it up or is there some way I can get that profile data into my new environment?


How to upgrade from Windows SharePoint Services 2.0 to SharePoint Foundation 2010 after mistanely de


I need a detailed instruction on how to upgrade From Upgrading from Windows SharePoint Services 2.0  (SBS 2003 ) to SharePoint Foundation 2010.

Background of the case:

I have all my databases (STS-database and STS_Config) saved but, I forgot to save my Virtual Site )Companyweb site) and I mistakenly re-installed IIS on the SBS 2003, hence  I lost the companyweb site. Is this an issue to migrate to Sharepoint foundation 2010. The Sharepoint foundation 2010 is running on a Microsoft HyperV Server 2008 R2
Also, I have created a Virtual 2003 SRV ENT with Sharepoint Services 3.0 running on it. I also have attached my Databases STS_Database and STS_Config)... how do I get it working like a regular website. I have modified the CNAME record to reflect the new server... http://companyweb - it take me to the new site but it loads a blank page. I did create a new CompanyWeb Virtual site on the VHD 2003 server.
Your help is greatly appreciated.

Thanks for your prompt response. Nelson

SharePoint 2010: Upgrade Resource Center (Developers)

Are you ready to move to SharePoint 2010? Learn about upgrading customizations and reusing your code.

Preparing for SharePoint 2010 Upgrade Today

The SharePoint product team has provided guidance on a number of items that can help organizations prepare, and Service Pack 2 includes a key tool that can provide additional insight and configuration information. This paper, by Quest SharePoint senior architect and evangelist Joel Oleson, walks you through using this key tool and offers major items to consider as you prepare for a SharePoint 2010 upgrade.

FullTextQuery not working after upgrade to SharePoint 2010

I have a function   Public Function QueryEx(ByVal webUrl As String, ByVal queryXml As String) As DataSet     Dim ds As DataSet = Nothing   Try   Dim myCredentials As NetworkCredential = CredentialCache.DefaultNetworkCredentials sws =   New SearchService.QueryService sws.Url = webUrl &   "/" & webServiceName   CType(sws, SearchService.QueryService).QueryEx(queryXml)     Catch ex As Exception lblDebug.Text =   "QueryEx: " & ex.Message pnlError.Visible =   True ds = Nothing   Finally sws.Dispose()   End Try   Return ds     End Function and passed the following full text query wrapped in the appropriate xml SELECT FileExtension, Filename, EffectiveDate, Title, Author, State, PolicyType, ApplicationType, PolicyNumber, ClientCode, CreatedBy, Created, ModifiedBy, LastModifiedTime, Path FROM portal..scope() WHERE ("SCOPE" = 'MyDeptScope') AND "IsDocument" = 1  AND ("Filename" LIKE 'Sub%') this worked in SharePoint 2007. We upgraded to SharePoint 2010.  I have all the managed properties setup the same on both versions.  I had to modify the query to get past one error I was receiving to SELECT FileExtension, Filename, EffectiveDate, Title, Author, State, PolicyType, ApplicationType, Pol

HTTP Error 500.19 - Internal Server Error after SharePoint 2010 In-place upgrade

Hello We have done an SharePoint 2010 In-Place Upgrade. After the upgrade, we can access the Central Administration page without problems. However, when accessing the standard http port 80 site, the following error appears: Error Summary HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid.   <fieldset><legend>Detailed Error Information</legend> Module IIS Web Core Notification Unknown Handler Not yet determined Error Code 0x80070032 Config Error The configuration section 'system.web.extensions' cannot be read because it is missing a section declaration Config File \\?\C:\inetpub\wwwroot\wss\VirtualDirectories\80\web.config Requested URL http://coolsharepoint:80/ Physical Path   Logon Method Not yet determined Logon User Not yet determined </fieldset> <fieldset><legend>Config Source</legend> 534: </location> 535: <system.web.extensions> 536: <scripting> </fieldset>

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.

problem rename sharepoint 2010 search service application admin database

Hi all, i have a problem that hopefully someone has an answer to.  i am not too familiar with sharepoint so please excuse my ignorance. we have sharepoint 2010 on a windows 2008r2 server.  everything seems to work fine.  but as you know, the default database names are horrendous.  i have managed to rename all of them, except for the "search service application" admin database. the default is: Search_Service_Application_DB_<guid> the other 2 databases (crawl and property) were renamed without a problem. we are following the article from technet on how to rename the search service admin db (http://technet.microsoft.com/en-nz/library/ff851878%28en-us%29.aspx).  it says to enter the following command: $searchapp | Set-SPEnterpriseSearchServiceApplication -DatabaseName "new database name" -DatabaseServer "dbserver" however, i get an error about identity being null.  no big deal, i add the -Identity switch and the name of my search service application.  but the real problem comes the error it throws:   Set-SPEnterpriseSearchServiceApplication : The requested database move was aborted as the associated search application is not paused. At line:1 char:54 + $searchapp | Set-SPEnterpriseSearchServiceApplication <<<<  -Identity "Search Service Application" -DatabaseName "ShareP

Meeting Workspace unusable after SharePoint upgrade to 2010

Hello, We recently took a content database from MOSS 2007 and attached it to a SharePoint 2010 farm that uses a different DNS name. Now, there's a user who had a recurring meeting configured in Outlook 2010 with a meeting workspace  who can no longer use the workspace now that it only exists on SharePoint 2010. She tried removing the link to the old workspace from her recurring meeting and adding a new location using the new URL, but she gets a message saying a workspace already exists at the site. Obviously it does, but the meeting in Outlook is the same meeting. Is there any way to re-connect the Outlook meeting with the meeting workspace that exists on the new SharePoint 2010 server? Thanks.

SharePoint 2010 in place upgrade "Cannot complete the action"

I currently did an inplace upgrade to SharePoint 2010 Standard in a medium farm deployment with one WFE and a remote SQL server with one site collection.  The upgrade process was marked as finished in CA.  The problem now is with the root site in the site collection is throwing the error "Cannot complete the action".  I've narrowed it down to the "Pages" library in the the root site.  The root site is using site template id = 20 template name = SPS#0, and template title = SharePoint Portal Server Site.  If I hard code the URL in IE address bar I can get everywhere on the root site including the settings page of the "Pages" library.  The error is thrown when I try to access the "Manage Permissions" link of the "Pages" library or when I try to browse to http://<rootsite>/pages/default.aspx. I believe the default.aspx page was customized by the customer when they were on SharePoint 2007 Standard.

database attach method migration wss3.0 to foundation 2010

I am confused in data base attach migration method for the follwoing scenario .Can you please give me clarity? it is urgent. We have a production system in wss3.0. I took  backup of the content database using sql servr management studio tool. Can I restore this content DB to a test environment ( on sun Virtual box with 'windows 7' 64-bit host OS) and from test env't to new production system?  If my testing is done and ready to move to new production system then How can I add the data accumulated during testing period (one month) to new prod'n system from wss3.0 system. Best regards,

Access Denied/The workflow could not copy the item workflow error after Sharepoint 2010 upgrade

We have a sharepoint designer workflow that copies a document from one library to another on the same site.  Before the upgrade to 2007 it worked fine, but now with 2010 it gives an error and cancels the workflow when it gets to the copy list item step.   The error on the workflow page: The workflow could not copy the item. Make sure the source and destination lists have the same columns and column settings.  Access Denied   Specifically it is the "copy list item current item to documentlibrary" sharepoint designer workflow action.   I have given the system account full permissions to the library and double checked that all columns are the same in both libraries. These are the verbose trace logs:   09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72er Medium System.UnauthorizedAccessException: <nativehr>0x80070005</nativehr><nativestack></nativestack>Access denied. at Microsoft.SharePoint.SPFile.UpdateInternal(Boolean migrationSemantics, Boolean reGhost) at Microsoft.SharePoint.Workflow.SPWinOEWSSService.CommitCopyFile(Transaction txn, Object[] transData) 09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72fe High Error in commiting pending workflow batch items: Sys

MOSS 2007 upgrade to Sharepoint 2010 across domains

I recently did an upgrade at a customer site. I migrated their content successfully as well as their Mysites. Their MOSS farm was situated on a domain, let's say "domain 1". Due to a merger, their domain had to change to "Domain 2". The Sharepoint 2010  farm was set up on new domain. We now need to change the existing user logins from the upgraded content db to the new domain. domain1\user to Doamin2\user.  We considered a manual process, but it is simply not a viable option. Furthermore, the migrated mysites works fine, but the problem is, the users need to login with their old login details to view the content. Which is unacceptable. The mysite content now needs to be associated with the users on the new domain. Bear in mind that the users already have logins and permissions as per the previous configuration (domain1\user) I consideredd using the stsadm migrate user command, but that could also be laborious. The other concern is the SID associated to each login. I am not sure if the -ignoresidhistory switch will help, or if this command is even usable in SP 2010. I there possibly another, more effective method to accomplish these tasks, say a Powershell script or a magic wand?   Regards,   Warren  
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