SBS 2011 Moved Sharepoint Databases to another SQL Server – Learnings

Written by James McDonald

April 10, 2013

Followed  the instructions at

Moved all sharepoint databases to a new server.

I left the SERVER_NAME\SHAREPOINT instance installed on the SBS 2011 box but have found that backups are failing because Backup Exec is trying to access the databases through that instead of through the SQL Client Configuration which interestingly has an alias named “SERVER_NAME\SHAREPOINT” that points to the new server. (A heap SQLVDI errors etc).

So on the SBS 2011 box I went into control panel

  1. Un-install a program and
  2. selected “Microsoft SQL Server 2008 R2 (64-bit)” and
  3. right clicked and chose “Change/Uninstall”
  4. selected the Remove option
  5. Waited for the validation step to complete
  6. Selected the “SHAREPOINT” instance
  7. Selected “database engine”, Full text and something else I can’t remember
  8. Clicked next till the end.

This removed the SHAREPOINT SQL instance and stopped Backup Execs confusion as to what SQL instance  needed to be backed up.


Submit a Comment

Your email address will not be published.

You May Also Like…

List your VSCode Extensions

Ever wondered what extensions you have installed and want to keep a list? This actually is a good way to audit your...