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. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.

You May Also Like…

Clear HSTS Settings in CHrome

Open chrome://net-internals/#hsts enter the domain in the query field and click Query to confirm it has HSTS settings...

Ubuntu on Hyper-v

It boils town to installing linux-azure # as root or sudo apt-get update apt-get install linux-azure...