June 18, 2010 at 5:57 am
Hi,
I'm going to plan to setup mirroring but in my database some sps are using xp_cmdshell. in the Stored Procedure the xp_cmdshell runs windows application, and some triggers are also execute xp-cmdshell in my database which I'm plaing to mirror
So I would like to know that what impects will happning on Mirroring when xp_chmshell will execute.
Thanks in Advance
Ram
MSSQL DBA
June 22, 2010 at 3:30 am
Hi,
I got the answer, Only changes will come from principal to mirror. Trigger will not fire and also xp_cmdshell will not run on mirror database.
Ram
MSSQL DBA
July 8, 2010 at 12:38 pm
Mirroring only handles DML changes to the data. If the external application that was called from xp_cmdshell modifies any data, then that data is mirrored. All data changes are mirrored.
By the way, calling an external application is a bad idea as the transaction is open longer than it should be. Just had to throw that in!
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
Ramblings of a DBA (My SQL Server Blog)[/url]
Subscribe to my blog
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply