Monday, October 5, 2009

Moving SharePoint Databases

  • Shut down all services on all front ends:
Net Stop SPTimerV3
Net Stop SPSearch
Net Stop OSearch
Net Stop SPAdmin
Net Stop SPTrace

iisrest /stop
  • Copy all databases to new server.
  • Run this command on all front ends:
STSADM.exe -o RenameServer -OldServerName DB01 -NewServerName DB02
  • Restart all services or restart server(s).
IISReset /start
Net Start SPTrace
Net Start SPAdmin
Net Start SPSearch
Net Start OSearch
Net Start SPTimerV3

  • Launch central admin and verify that default databse has changed (Operations, Default Database Server)!7545065B20709461!273.entry

No comments:

Post a Comment