tech·nic·al·ly agile

The SharePoint Plan: Database move headache mitigation

Discover effective strategies to mitigate database move headaches in SharePoint. Learn how to simplify SQL Server migrations and save time with our expert plan!

Published on
1 minute read
Image
https://nkdagility.com/resources/8G7jFUB3MHo

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!

Technorati Tags: Fail    SP 2007 

Comments

Related blog posts

No related videos found.

Connect with Martin Hinshelwood

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.

Our Happy Clients​

We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.​

Genus Breeding Ltd Logo
Workday Logo
Milliman Logo
Philips Logo
Teleplan Logo
Slaughter and May Logo
Freadom Logo

NIT A/S

Hubtel Ghana Logo
Higher Education Statistics Agency Logo
ALS Life Sciences Logo
Graham & Brown Logo
Alignment Healthcare Logo
Ericson Logo
Microsoft Logo
DFDS Logo
Jack Links Logo
Deliotte Logo
Washington Department of Enterprise Services Logo
Ghana Police Service Logo
New Hampshire Supreme Court Logo
Nottingham County Council Logo
Department of Work and Pensions (UK) Logo
Royal Air Force Logo
SuperControl Logo
Schlumberger Logo
ALS Life Sciences Logo
New Signature Logo
DFDS Logo
Slaughter and May Logo