Unsolved
This post is more than 5 years old
2 Posts
0
667
June 4th, 2015 08:00
Scheduled SQL Database Cloning
Greetings all,
Does anyone know if there is a way to facilitate a database cloning process through a VNX application suite or process? We have a VNX 5200 block storage unit. I'm pretty sure I can do this through SQL Management (SQL 2012 Ent), but since the data already resides on VNX storage I thought I could save some time and storage space (the combined database and log files amount to roughly 350 GB).
I have 2 DB servers (we'll call them SQLA and SQLB) that both run a daily process which pulls data from the same source into a database, calling this DataDB. The DataDB data and log files in both SQL instances reside on their own individual LUNs. My goal here is to run the load process once a day to create SQLA.DataDB (cutting out the second redundant load process), then clone to SQLB.DataDB. The key here is that clone process needs to be scheduled to run daily and then ensure the databases are mounted in both SQL instances when finished.
I've played around with an AppSync snapshot copy of SQLA.DataDB and mounting it to SQLB.DataDB, the problem is that the application doesn't have an option to automate this process. I've also looked at creating clones through Unisphere Management Console, but scheduling here is also not an option.
Can someone tell me if this is possible using a VNX toolset or application suite, or am I better off setting this up in SQL instead?
0 events found
dynamox
11 Legend
•
20.4K Posts
•
87.4K Points
0
June 4th, 2015 12:00
i thought AppSync was designed for automating things like that ? Which step did not work or was not available ?
umichklewis
4 Apprentice
•
1.2K Posts
0
June 4th, 2015 12:00
If you're integrated with VMware, the VSI integration with EMC AppSync has some scheduling functionality.
If you're not using VSI, you might look at creating a scheduled in Windows Scheduler from the SQL server, and kicking off a PowerShell command or batch file to run the necessary VNX commands. In the old days, much of this could be handled from Replication Manager - you might be able to dig up the 30-day trial and test that.
Let us know if that helps!
Karl
epollen
2 Posts
0
June 15th, 2015 07:00
Thanks to both of you for your replies, it has been a while since I've tinkered with AppSync after setting it up originally. I did indeed miss the part during the Service Plan creation wizard where you can mount and unmount database copies and set that to a schedule. I'm playing around with it right now and it looks to be what I'm looking for.
Thanks again!