MSSQL LUN Migration with Snapmirror

[kwana]

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]

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]

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]

Thanks all reply!!

Alex