Unsolved
This post is more than 5 years old
4 Posts
0
5839
ASM and SQL Smart Copies
I have two questions about ASM and SQL Server.
1. I have a database called VSSTEST1 that is stored on a PSxxxx volume and have created a Full Snapshot Smartcopy using ASM. I can use ASM to restore the snapshot using the “Restore selected databases” option and specify that I want to apply logs. After that I can apply transaction logs. What I want to do is restore the snapshot using a different database name (e.g. VSSTEST2) and have it still be in “recovery” mode so that I can restore transaction log backups. ASM doesn’t let me do that. If I could generate a script to do the restore, I could modify the database name before executing the script.
2. Why can't I do the same type of restore using a replica Smart Copy. I don’t want to have to set up both Replica Smart copies and Snapshot smart copies for the same database. I would like to know if there are plans to combine those two, or if there is a way to attach a replica in such a way that I can do a manual restore from within SQL server just like I would with the backups that I create now.
Thanks,
Steve
1. I have a database called VSSTEST1 that is stored on a PSxxxx volume and have created a Full Snapshot Smartcopy using ASM. I can use ASM to restore the snapshot using the “Restore selected databases” option and specify that I want to apply logs. After that I can apply transaction logs. What I want to do is restore the snapshot using a different database name (e.g. VSSTEST2) and have it still be in “recovery” mode so that I can restore transaction log backups. ASM doesn’t let me do that. If I could generate a script to do the restore, I could modify the database name before executing the script.
2. Why can't I do the same type of restore using a replica Smart Copy. I don’t want to have to set up both Replica Smart copies and Snapshot smart copies for the same database. I would like to know if there are plans to combine those two, or if there is a way to attach a replica in such a way that I can do a manual restore from within SQL server just like I would with the backups that I create now.
Thanks,
Steve
Donald_Williams
72 Posts
0
June 11th, 2010 15:00
• In regards to replica smart copies we have to set up two different smart copy schedules because we base our snapshot and replica capabilities in ASM on those of the PS Series software and that’s how it works today.
I'm not sure I fully understand the last question. "if there is a way to attach a replica in such a way that I can do a manual restore from within SQL server just like I would with the backups that I create now."
If you mean can I access a replica directly and mount it to the SQL server and access the data, the answer is yes. You can either promote or clone the replica (cloning is preferred since it doesn't interrupt replication). You can then attach to the clone and see it as another drive.
Regards,
-don
hics0
4 Posts
0
June 14th, 2010 09:00
Thanks,
Steve