Data Backup and Recovery

Moving SQL Databases between filers

Willybobs27

Can I use Snapmanager for SQL to move Databases between filers?

Old filers are being decommissioned.

Or is there a better, easier way?

2 REPLIES 2

parkerj

There are many ways to accomplish this.  If you can afford the downtime then ensuring that the host has both sets of LUNs attached to it then running the configuration wizard and migrating the database is an easy one.  You can also detach the databases, then copy the databases to the new locations, and reattach the databases.  Either of these two methods are fine if you can have some downtime to make the database moves.  If downtime is an issue then you can use database mirroring to accomplish this task.  The steps for database mirroring are in a blog post on the MS Enviro blog. http://blogs.netapp.com/msenviro/2009/12/data-migration.html#more

Best of luck

John

sourav

Absolutely. You need to ensure that the target database LUNs are connected to the current host. Then you can use the Configuration Wizard.

Regards,

Sourav.

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public