Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks all reply!!
Alex