Are CLR libraries mirrored when using SQL Server mirroring?

I have a SQL Server database (2008) in which I have some CLR DLLs that SQL uses for different things.

Are these DLLs mirrored when I use SQL mirroring? Our DBA says no, but I find it crazy and cannot find much information about it on the Internet.

Is it possible to mirror the CLR DLL?

+3
source share
2 answers

CLR . sys.assemblies, master.sys.assemblies DMV, DMV. , , . , UNSAFE, TRUSTWORTY, , , . , , , , . , SQL, . .

http://sqlblog.com/blogs/jonathan_kehayias/archive/2008/03/06/clr-safety-issues-after-database-restore-to-new-server.aspx

, , . .

+4

, : , msdb - .

+1

Source: https://habr.com/ru/post/1712451/


All Articles