Article: Centralized Asynchronous Auditing across Instances and Servers with Service Broker

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

Article Discussion

Article: Centralized Asynchronous Auditing across Instances and Servers with Service Broker

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-08-20 : 08:03:31

In my

previous article I showed how to asynchronously audit data in one
instance with one central database that holds audited data from all other
databases on that instance. So to continue showing the greatness that is Service
Broker this article explains how to do the same with multiple servers or
instances. This means that a single server holds audited data from all other
servers. It's a classic many to one (one to many) scenario. Note that this
technique works also if you want to send data from the master server to multiple
children servers.

Read Centralized Asynchronous Auditing across Instances and Servers with Service Broker

alzdba
Starting Member

10 Posts

Posted - 2007-08-23 : 10:18:15

Nice article sequence.
I've publised a similar one about taking SSB off-instance, with step-by-step scripts for different scenarios.

You can find it at http://www.sqlservercentral.com/columnists/jbijnens/2897.asp

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-23 : 12:11:36

thanx!

i haven't seen your until now... if i had... hell i wouldn't even bother

just kidding! i would! Service Broker is a lot of fun!
especially when it takes all of your servers resources with message poisoning

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

alzdba
Starting Member

10 Posts

Posted - 2007-08-24 : 01:41:45

mglalo
Starting Member

2 Posts

Posted - 2009-06-15 : 16:40:31

In testing the script, for:

BACKUP CERTIFICATE CertificateAuditDataReceiver
TO FILE = 'C:\CertificateAuditDataReceiver.cer'

GO

I get:
Msg 15240, Level 16, State 1, Line 1
Cannot write into file 'C:\CertificateAuditDataReceiver.cer'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.

Any ideas?

Thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2009-06-15 : 16:51:02

the sql server service account you run it under doesn't have permissions for accessing c: disk

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.5 out!

mglalo
Starting Member

2 Posts

Posted - 2009-06-16 : 10:01:37

spirit1, Thanks! I was able to run it successfully on other path.

kauts
Starting Member

2 Posts

Posted - 2010-07-19 : 03:50:18

Hi all

I hav got a strange problem with this asynchronous auditing. My auditing is working fine if i send the messages one at a time. But when i make the system live it is not working. My live system has about 50 commands fired per minute (or more).The activation proc calls a c# program as well as a few xp_cmdshell commands. I hav set the max_queue_readers to 200. Can anybody help me out??
Thanks in advance...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources