0

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.

Improve this question
5
  • SUSDB is the backend for WSUS Commented Jan 10, 2012 at 0:15
  • So do I need to migrate it to 2010 or will it get recreated in 2010 in another shape or form? Commented Jan 10, 2012 at 0:43
  • Oh WSUS = Windows Shared Update Services, so I'm guessing no. Commented Jan 10, 2012 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. Commented Jan 10, 2012 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. Commented Jan 12, 2012 at 2:59

1 Answer 1

Reset to default
1

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.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.