a·gen·tic a·gil·i·ty

The SharePoint Plan: Database move headache mitigation

Guidance on moving SharePoint SQL Server databases to a new server using DNS redirection, aiming to simplify migration and minimise downtime and manual effort.

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

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

Subscribe

Related Blog

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.​

Emerson Process Management Logo

Emerson Process Management

Hubtel Ghana Logo

Hubtel Ghana

Slaughter and May Logo

Slaughter and May

Qualco Logo

Qualco

MacDonald Humfrey (Automation) Ltd. Logo

MacDonald Humfrey (Automation) Ltd.

Kongsberg Maritime Logo

Kongsberg Maritime

Teleplan Logo

Teleplan

DFDS Logo

DFDS

Slicedbread Logo

Slicedbread

Epic Games Logo

Epic Games

Higher Education Statistics Agency Logo

Higher Education Statistics Agency

Workday Logo

Workday

Graham & Brown Logo

Graham & Brown

Brandes Investment Partners L.P. Logo

Brandes Investment Partners L.P.

SuperControl Logo

SuperControl

Big Data for Humans Logo

Big Data for Humans

YearUp.org Logo

YearUp.org

Xceptor - Process and Data Automation Logo

Xceptor - Process and Data Automation

New Hampshire Supreme Court Logo

New Hampshire Supreme Court

Ghana Police Service Logo

Ghana Police Service

Nottingham County Council Logo

Nottingham County Council

Washington Department of Transport Logo

Washington Department of Transport

Department of Work and Pensions (UK) Logo

Department of Work and Pensions (UK)

Royal Air Force Logo

Royal Air Force

Slicedbread Logo

Slicedbread

Big Data for Humans Logo

Big Data for Humans

Workday Logo

Workday

Lockheed Martin Logo

Lockheed Martin

Akaditi Logo

Akaditi

Brandes Investment Partners L.P. Logo

Brandes Investment Partners L.P.