July 2, 2011 at 3:33 am
Hello,
Does any body know how to use vss in data mining?Any good resource on this topic?I'm familiar with this subject, but I don't know it in details. I have questions like "how the snapshot is restored on the secondary server?should I restore it periodically or there is no need to restore and it'll be updated automatically?"
July 2, 2011 at 11:03 am
See section "Data mining by using transportable shadow copies" here:
http://technet.microsoft.com/en-us/library/ee923636(WS.10).aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 4, 2011 at 12:59 am
Thanks for your kind reply.
I'd seen this page before. But it has not described the process in detail. I'm looking forward for a more technical and applicable resource. I can't understand how to implement it. Even a brief overview would be suficient , if it's applicable.
July 4, 2011 at 7:38 am
Are you trying to initiate a shadow copy on your own? Typically a backup software or hardware management software interacts with VSS for you. What are you trying to do?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 7, 2011 at 4:25 am
I'm so thankfulness of you for helping me. That's so kina you.
Some thing like what you said,
I want to have a SAN storage. 2 servers connected to it. The primary server has a database called X which is used for reporting. This database is a heavy database and reporting from it impacts performance. This database is placed in a Vdisk called Vdisk1. I want to use a secondary server to use database X for reporting , in this way I cal balance primary server workload. How can I synchronize database in primary server with database in secondary server without impacting performance? My idea is putting database for the secondary server on Vdisk2 and synchronizing these Vdisks at the hardware level to have same data on 2 servers. Is it possible? Is this synchronization online? Do I have to attach the database at the secondary server , every time I do a snap clone job? What's the best way to resolve this issue?
Have fun
Parissa Bakhshi
July 7, 2011 at 6:27 am
Many SANs have snapshot utilities that get can take a transaction-consistent snapshot of a SQL Server database and place it on a different volume just how you're wanting. VSS is probably involved in operations like that and the for speed reasons the SAN copies the data at the block level. What kind of SAN do you have? Check with the vendor to see if what you're trying to do is available for your model. They can likely guide you since every vendor's software and hardware capabilities will be different.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 7, 2011 at 7:31 am
Actually we don\t have a SAN, but planning to buy an HP EVA if it supports this feature. You mean if I do a snap clone or local replication on storage level, then I can have to online databases? The secondary database would be online or it needs to be attached every time?
July 7, 2011 at 8:02 am
parissa_bakhshi (7/7/2011)
Actually we don\t have a SAN, but planning to buy an HP EVA if it supports this feature. You mean if I do a snap clone or local replication on storage level, then I can have to online databases? The secondary database would be online or it needs to be attached every time?
It depends on the SAN software. EquaLogic has a managed SAN that can snap a DB and bring it online in another instance in one motion if both instances are hosted on the same SAN.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply