SharePoint requires SQL Server. That’s a given, but what if you want to move the SQL Server databases to another server? TFS is easy enough to move between servers, but SharePoint is NOT. The only answer I can find is to do a full backup and restore from SharePoint, which takes time and effort.
The Plan
I will use a local SQL server with a named instance of “EPDev”, but I will also use a DNS name for the server “dpdata.ep-dev.[domain].biz”. This will allow me to, hopefully, move the databases without having to spend the weekend doing it. I should be able to backup and turn off the SQL server. Re-point “dpdata.ep-dev.[domain].biz” to the new SQL Cluster and restore the databases to the “dpdata.ep-dev.[domain].biz/EPDev” instance on that server. Then I will bring up the SharePoint server. This should work, but I have not as yet tested it…
Hopefully this will not screw up, but I will take steps to provide for that
probability possibility…
Microsoft: if you are listening, please make moving a SharePoint database as easy as TFS!
No related videos found.
If you've made it this far, it's worth connecting with our principal consultant and coach, Martin Hinshelwood, for a 30-minute 'ask me anything' call.
We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.
Emerson Process Management
Hubtel Ghana
Slaughter and May
Qualco
MacDonald Humfrey (Automation) Ltd.
Kongsberg Maritime
Teleplan
DFDS
Slicedbread
Epic Games
Higher Education Statistics Agency
Workday
Graham & Brown
Brandes Investment Partners L.P.
SuperControl
Big Data for Humans
YearUp.org
Xceptor - Process and Data Automation
New Hampshire Supreme Court
Ghana Police Service
Nottingham County Council
Washington Department of Transport
Department of Work and Pensions (UK)
Royal Air Force
Slicedbread
Big Data for Humans
Workday
Lockheed Martin
Akaditi
Brandes Investment Partners L.P.