Data Backup and Recovery

Moving SQL-Databases to another LUN with same Letter - dependency to SnapManager SQL?

DonLeon
2,905 Views

Hello community,

 

i need a little statement. We are running SQL Server 2012 with SnapManager. The databases are located on LUNs with a few driveletters (DB, TA, Logs). Now we have to backup and restore the database because we reached the end of the LUN-geometry. So we plan the following szenario:

 

1. Backup the running database.
2. Detach the database in SQL-Mgmt.

3. Detach the old LUNs (DB, TA, Logs).

4. Attach the new LUNs with new geometry and size (DB, TA, Logs).

5. Assign the old driveletters to the new LUNs

6. Restore the database-backup to the new LUNs

7. Attach the database and take it online.

8. Finish: All databases and drives should have the same names as before.

 

Question: Are there any dependency to the SnapManager installation? Or just we need to make a clean reboot and everything also the SnapManager Jobs should running fine?

 

Thanks for your replys and have a nice day.

5 REPLIES 5

Trubida
2,883 Views

If you are using SnapManager you could actually create the new LUNS, assign drive letters and then use SnapManager to migrate the data to the new LUNS.  Here's a link that walks you through the process.  

https://library.netapp.com/ecmdocs/ECMP1649831/html/GUID-C4DE2F10-AD73-4FA7-B99D-A76D1E0CEF2C.html

 

If you don't want to do that then the process you have below should work fine and shouldn't cause any issues with SnapManager.

DonLeon
2,881 Views

Hi Trubida,

 

thanks for your fast reply. we have to use same letters and want to optimize the filesizes. so we decided to use the nativ way.

 

you wrote:

"If you don't want to do that then the process you have below should work fine and should cause any issues with SnapManager.

 

Do you mean "should cause any issue with smsql" or "not cause"?

 

thanks and have a great day

Trubida
2,864 Views

Sorry, haven't had my second cup this morning.  The way you have it listed shouldn't cause any problems.  

DonLeon
2,860 Views

Ok thanks, same by me, need also a second one 😉

 

i'm sorry but one more question 😉 what about the old snapshots that may still be kept in SnapManager? Will the volumes be rediscovered by SnapDrive, and so would SnapManager be happy?

 

thank you

Trubida
2,840 Views

After you move the data I would run through the configuration wizard in SnapManager.  That should take care of any updates that need to be done.

Public