sharepoint 2013 Database migration to new SAN

Dear Experts,

We have two DB servers with shared SAN storage. we have presented same LUNs to both the DB servers.

Now we have brought new SAN storage for sharepoint  servers. Please advice the best way to migrate the production Databases to new SAN.

We have sharepoint 2013 MS Sql 2012

Thanks
tabreedAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Best way should be stop SharePoint and SQL Server, then copy the databases files to the new SAN and present the LUNs to the server with the same drive letters and folder structures so when you start SQL Server you won't need to perform any additional task.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark WillsTopic AdvisorCommented:
And Vitor has written  Articles that might be of interest to you about how to copy.

See http://www.experts-exchange.com/articles/22159/SQL-Server-database-migration-The-Copy-Database-Wizard-method.html and note the links to the other methods. The detach / move / attach is possibly the more common.

Not sure if it is Replacement SAN, Additional SAN, or simply going to be a new (replacement) home for SharePoint + SQL. That might make a difference as to your approach. Might also be additional steps depending on if you have customisations/webparts etc,or, keep image/blob type data in SharePoint DB or externally on disk.

But, make very sure you do a FULL farm and db backup before you do anything , and best to make sure you can practise first to get accurate timings before committing to the new location.

And, if you didn't do the original install, might be worthwhile going through an install on your new SAN first and note the steps as a "test environment" before the new storage is put into production, or decommission the old. Will definitely need to be SharePoint Admin.

Also look at the Steps Graphics / Posters (mainly the one in the middle down the bottom) on : https://technet.microsoft.com/en-us/office/dn788776 It can be more than just copying DB's and is a good checklist to have handy.

And don't forget to read Vitor's article... That part you will DEFINITELY need at some stage.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.