Data Backup and Recovery

Moving SQL Databases between filers

Willybobs27
2,318 Views

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

sourav
2,318 Views

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.

parkerj
2,318 Views

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

Public