?
Solved

SBS 2008 to SBS 2011 Migration - Sharepoint Issue

Posted on 2011-05-09
14
Medium Priority
?
2,361 Views
Last Modified: 2012-05-11
Hello All,

 I have successfully done a migration from SBS 2008 to SBS 2011.

 The only issue that is holding me from wrapping it up is migrating sharepoint.

 I have follow Microsoft's instructions to the letter about moving SharedWebDb, but that only moves over the layout and not the content. I have exported the WSS_Content from SQL Managerment Studio Express but cannot seem to mount the database.

 The database is only 200MB in size, but I just am at a loss.

 Anyone have any ideas?

 Thanks!
0
Comment
Question by:LindsayCole
  • 7
  • 7
14 Comments
 
LVL 5

Expert Comment

by:Christopher White
ID: 35721383
There are a few ways of doing this.

Create a new web application in your new instance of SharePoint. (They are the same version correct ?)

Detach the Content database from the web application.

Mount the WSS_Content DB from the old instance of sharepoint to the new SQL instance.

Attach that DB under
 
Central Administration  Manage Content Database Settings.


if you want a walk through I need to know what version of SharePoint you are using ?
0
 
LVL 2

Author Comment

by:LindsayCole
ID: 35721616
I'm sorry SBS 2008 natively has SharePoint 2007 natively with it, and SBS 2011 has SharePoint 2010.

So I am migrating from 2007 to 2010.

I tried your steps, (even though not same version)- and it comes back with this error;

Cannot open database "WSS_Content_044f4f89-6463-4b57-8c4e-6d21772bb165" requested by the login. The login failed.
Login failed for user 'SPARTAN\spfarm'

Correlation ID: 156ca977-8d3d-4588-b454-5c8337b545b8

Date and Time: 5/9/2011 12:59:00 PM

I would love any step by step instructions you could provide, I have been spinning my wheels on this for a week.

 Thanks!
0
 
LVL 5

Expert Comment

by:Christopher White
ID: 35721747
Your SBS2008 to SBS2011 is that Linked to the same domain?

And if you are doing 2007 to 2010 you should run a prep on the database before you move it to 2010, but in the past I have managed to bypass this.

When you moved the database over, it took all the old usernames and passwords from the old instance.

links to Microsoft help on database attached migration/upgrade  http://technet.microsoft.com/en-us/library/cc263299.aspx
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 2

Author Comment

by:LindsayCole
ID: 35721816
I have done the pre-upgrade check- and yes both are in the same domain.

 I will give your article a try- it is different than the other few I have tried. I will respond either way, shortly.

Thanks!
0
 
LVL 2

Author Comment

by:LindsayCole
ID: 35723042
So I get an error;

PS SQLSERVER:\SQL\SPARTAN-SBS\SHAREPOINT\Databases> Mount-SPContentDatabase -nam
e WSS_Content_044f4f89-6463-4b57-8c4e-6d21772bb165 -database server spartan-sbs
-webapplication http://companyweb
The term 'Mount-SPContentDatabase' is not recognized as the name of a cmdlet, f
unction, script file, or operable program. Check the spelling of the name, or i
f a path was included, verify that the path is correct and try again.
At line:1 char:24
+ Mount-SPContentDatabase <<<<  -name WSS_Content_044f4f89-6463-4b57-8c4e-6d217
72bb165 -database server spartan-sbs -webapplication http://companyweb
    + CategoryInfo          : ObjectNotFound: (Mount-SPContentDatabase:String)
    [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

So I tried it using stsadm (yes- deprecated, but still useful);

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN>stsa
dm -o addcontentdb -url http://companyweb -databasename WSS_Content_044f4f89-646
3-4b57-8c4e-6d21772bb165

Exception of type 'Microsoft.SharePoint.Upgrade.SPUpgradeException' was thrown.

Any ideas?
0
 
LVL 2

Author Comment

by:LindsayCole
ID: 35723675
I managed to get the database to import;

I get this error on my Sharepoint when I go to it;

HTTP/1.1 200 OK
Server: Microsoft-IIS/7.5
Date: Mon, 09 May 2011 19:53:57 GMT
Connection: close

Any suggestions?
0
 
LVL 5

Expert Comment

by:Christopher White
ID: 35727053
Ah that does not sound good, resolvable but requires trouble-shooting on the Database which instead of doing that, can I ask that you try another approach (See your databases are most likely hosted in 2 different version of SQL). Delete that web application + Content Database and start fresh.

Once you have your web application. Create the root site/workspace. BLANK SITE is preferable.

Use stsadm (maybe old but does wonders)

On the old box run

stsadm -o export -url http://Hostname:3000/Site/Subsite/ -filename c:\FILENAME -nofilecompression –includeusersecurity

(** I will create a folder on the root of C:  in that folder will be lots of file copy that folder to the root of the new box)

on the new box

stsadm -o import -url http://Hostname:6000/Site/ -filename c:\FILENAME -nofilecompression –includeusersecurity

That would be the best option considering the SQL issue. let me know how that goes.
0
 
LVL 5

Expert Comment

by:Christopher White
ID: 35727106
Sorry that Export command may be misleading. Need to export the root site collection

most likely  ---> http://hostname:PORT/Pages/ 
0
 
LVL 2

Author Comment

by:LindsayCole
ID: 35728468
Yes- my source destination is in SQL 2005, where my destination is SQL 2008.

When I run the stsadm command to import, it throws an error;

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN>stsadm -o import -url http://companyweb -filename C:\backup -nofilecompression -includeusersecurity

The site http://companyweb could not be found in the Web application SPWebApplication Name=SBS SharePoint.

My SharePoint knowledge is quite low, and I suspect I'm doing something wrong at this point. Can you direct me?

Thanks!
0
 
LVL 5

Accepted Solution

by:
Christopher White earned 2000 total points
ID: 35728581
Ok just to make sure we are giving it the correct input.

Browse to the new site collection you created. (Can you paste it in so I can see the URL blank out the hostname)

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN>stsadm -o import -url http://companyweb/pages/ -filename C:\backup -nofilecompression -includeusersecurity

that bit in bold is important. but it could also be /sites  depends what was selected when making the first site collection.



0
 
LVL 2

Author Comment

by:LindsayCole
ID: 35729371
Okay, so;

 I started over completely again- just for giggles.

 Created a site called companyweb, which is located at http://companyweb/SitePages/Home.aspx

(The new top-level site was created successfully with the specified URL. If you have permission to view the Web site, you can do so in a new browser window by clicking the URL. To return to SharePoint Central Administration, click OK .

https://remote.spartansystems.ca:987)

This works, with no issues. Just empty- which is to be expected. A little background info about Small Business Server - it comes with Sharepoint preinstalled, at that location. Internally accessible at http://companyweb and externally at https://remote.domain.com:987.

I haven't imported the new site yet- just want to clarify something first- when I exported the site- I had used just http://companyweb - was that incorrect?
0
 
LVL 5

Expert Comment

by:Christopher White
ID: 35729443
:)

http://companyweb/SitePages/

Let me know how it goes.  
0
 
LVL 2

Author Comment

by:LindsayCole
ID: 35730453
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN>stsadm -o import -url http://companyweb/sitepages/ -filename C:\backup2 -nofilecompression -includeusersecurity

Start Time: 5/10/2011 12:02:02 PM.
Progress: Initializing Import.
Warning: Could not find Web Part [Unknown: a15ece40-e711-e81e-54e8-d17c618e0985] on page  in the safe controls list.
Warning: Export only contains the last major of a file.
FatalError: The version of the package 12.0.10.0 is different from the current version this program supports, 14.0.0.0.
Progress: Import did not complete.
Finish Time: 5/10/2011 12:02:07 PM.
Duration: 00:00:04
Finished with 2 warnings.
Finished with 1 errors.

Log file generated:
        C:\backup2\import.log

The version of the package 12.0.10.0 is different from the current version thisprogram supports, 14.0.0.0.
--

Import.log-

[5/10/2011 12:02:02 PM] Start Time: 5/10/2011 12:02:02 PM.
[5/10/2011 12:02:02 PM] Progress: Initializing Import.
[5/10/2011 12:02:05 PM] Warning: Could not find Web Part [Unknown: a15ece40-e711-e81e-54e8-d17c618e0985] on page  in the safe controls list.
[5/10/2011 12:02:06 PM] Warning: Export only contains the last major of a file.
[5/10/2011 12:02:07 PM] FatalError: The version of the package 12.0.10.0 is different from the current version this program supports, 14.0.0.0.
[5/10/2011 12:02:07 PM] Debug:    at Microsoft.SharePoint.Deployment.SPDeploymentSchemaVersion.Validate(SPSite site)
   at Microsoft.SharePoint.Deployment.SPImport.Run()
[5/10/2011 12:02:07 PM] Progress: Import did not complete.
[5/10/2011 12:02:07 PM] Finish Time: 5/10/2011 12:02:07 PM.
[5/10/2011 12:02:07 PM] Duration: 00:00:04
[5/10/2011 12:02:07 PM] Finished with 2 warnings.
[5/10/2011 12:02:07 PM] Finished with 1 errors.

When this occured, I did this;

The culprit is the line:
<SchemaVersion Version="12.0.10.0" Build="12.0.0.6514" DatabaseVersion="476278" SiteVersion="0" />
in SystemData.xml.

Replace Version="12.0.0.0" with Version="14.0.0.0"
and Build="12.0.0.6514" with Version="14.0.4762.1000".

Which fixed that error.

So I re-ran it;

And success!

A few minor problems, couple images don't work- can't seem to render- we have all of six images on the sharepoint anyway- not worth troubleshooting over.

You Chris- are a god among men.

Thanks!
0
 
LVL 5

Expert Comment

by:Christopher White
ID: 35731534
Think you deserve a pat on the back for that last bit well done.


0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

755 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question