Hello, is there an ITPro course that covers SQL server replication approaches and configuration?
Regards,
Adam Tyler
-
Microsoft SQL Replication
-
I believe Don covered some of this in the 70-462 show in our course library.
https://app.itpro.tv/course-library/microsoft-sql-server-2012/clustering-redundancy/This was an earlier format of our shows but the material is still good!
-
@Ronnie-Wong Thanks Ronnie! That show seems to be specific to clustering. Do you know if it covers other aspects of data distribution and availability with SQL? It seems there are a few options when it comes to availability now.. There is the traditional clustering and shared storage model.. Then there is log shipping, which M$ replaced with Database Mirroring.
On top of that, there is a completely different option as I under stand it called Replication via SQL snapshots or at the transaction level.. This isn't really meant for availability, but more of a way of getting data distributed to multiple places throughout an organization. Perhaps for query optimization or reporting purposes...
Regards,
Adam Tyler -
I'm pretty sure then that there isn't anything else that we have in our library for that specific topic of Replication via SQL snapshots.
