Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

This is a follow on question from, Use backup restore then attach in Sharepoint 2007 to 2010 migration.

There are 5 databases in the SQL Server Instance for Sharepoint Server 2007:

  1. Sharepoint_AdminContent
  2. SUSDB
  3. WSS_Content_CompanyName_Intranet
  4. Sharepoint_Config
  5. WSS_Search_WINXXX

Which databases do I backup so that I may restore them on the new SQL Server 2008 R2 instance ready for migration to Sharepoint 2010? In particular what is "SUSDB"? Currently, I have backed up items 1, 2, and 3 and I don't believe I will have to migrate the search and config databases.

share|improve this question
    
SUSDB is the backend for WSUS –  Ben Pilbrow Jan 10 '12 at 0:15
    
So do I need to migrate it to 2010 or will it get recreated in 2010 in another shape or form? –  Seth Jan 10 '12 at 0:43
    
Oh WSUS = Windows Shared Update Services, so I'm guessing no. –  Seth Jan 10 '12 at 0:43
    
The WSUS db is nothing to do with sharepoint - this server is either also your WSUS server or the SQL backend has been moved to this server. Either way, sharepoint won't create SUSDB, since it's not related. –  Ben Pilbrow Jan 10 '12 at 0:57
    
So we have knocked off SUSDB, #2, #4 and #5. What about Sharepoint_AdminContent? It seems that will get recreated when the Sharepoint 2010 system is installed. –  Seth Jan 12 '12 at 2:59
add comment

1 Answer 1

up vote 1 down vote accepted

1.SharePoint_AdminContent is for the Central Administration content DB so you don't need backup. same with 2.4 & 5 you can leave it. Only back up you need is WSS_Content _Intranet_db http://sharepoint2010blog.blogspot.com/2010/01/how-to-upgrade-to-sharepoint-2010-using.html You can check the following series and many more regarding migration.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.