MSSQL LUN Migration with Snapmirror

kwana · ‎2012-11-16

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 · ‎2012-11-16

Hi

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 · ‎2012-11-16

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 · ‎2012-11-18

Thanks all reply!!

Alex