Hello, is there an ITPro course that covers SQL server replication approaches and configuration?
Regards,
Adam Tyler
Microsoft SQL Replication
Hello, is there an ITPro course that covers SQL server replication approaches and configuration?
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.
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.