topic Re: MSSQL LUN Migration with Snapmirror in ONTAP Discussions

MSSQL LUN Migration with Snapmirror

kwana — Thu, 05 Jun 2025 06:15:14 GMT

Hi All,

Can I use snapmirror for data migration of MSSQL DB and Log LUN? ( Customer use Snapmanager for MSSQL backup the SQL database)

e.g

1) Snapmirror original DB voluume -> destination volume,

2) Snapmirror update after stop SQL service on server

3) Dismount the DB and Log LUN on the source filer

4) Mount the DB and Log LUN on the destination filer

5) Start the MSSQL service

Thanks

Alex

nigelg1965 — Fri, 16 Nov 2012 09:59:06 GMT

Yes, that's pretty much it. We've done this numerous times.

There's a couple of extra bits just to clarify.

3.1 Quiesce the snapmirror

3.2 Break the snapmirror

martin_fisher — Fri, 16 Nov 2012 16:40:19 GMT

Hi Alex - in short yes. Completed this many times as well, with SMSQL and SME.

I would add a few other steps in as well.

1) Snapmirror original DB voluume -> destination volume,

2) Stop SQL service on Server/Application Server, to prevent any further data writes/ I/O

2.1 Take a Final Snapshot of the LUN's with either SnapDrive or via the CLI.

2.2 Run a LUN show -v for all the LUN's and copy the information, including LUN ID's and Serials.

2.3 Snapmirror update from destination filer and check for completion.

3) Dismount the DB and Log LUN on the source filer

3.1 Quiesce the snapmirror

3.2 Break the snapmirror on the destination filer.(The volume should then use to the last snapshot taken by SDW or the CLI, in 2.1)

4) Mount the DB and Log LUN on the destination filer

4.1 Check LUN ID's & Serials.

5) Start the MSSQL service

6) Test Drive and check all LUN's mount etc.

Cheers

martin

kwana — Mon, 19 Nov 2012 06:42:41 GMT

Thanks all reply!!

Alex