SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Centralized Asynchronous Auditing across Instances and Servers with Service Broker
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 08/20/2007 :  08:03:31  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote

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

Belgium
10 Posts

Posted - 08/23/2007 :  10:18:15  Show Profile  Reply with Quote
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

Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 08/23/2007 :  12:11:36  Show Profile  Visit spirit1's Homepage  Reply with Quote
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

Edited by - spirit1 on 08/23/2007 12:12:48
Go to Top of Page

alzdba
Starting Member

Belgium
10 Posts

Posted - 08/24/2007 :  01:41:45  Show Profile  Reply with Quote
Go to Top of Page

mglalo
Starting Member

USA
2 Posts

Posted - 06/15/2009 :  16:40:31  Show Profile  Reply with Quote
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

Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 06/15/2009 :  16:51:02  Show Profile  Visit spirit1's Homepage  Reply with Quote
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!
Go to Top of Page

mglalo
Starting Member

USA
2 Posts

Posted - 06/16/2009 :  10:01:37  Show Profile  Reply with Quote
spirit1, Thanks! I was able to run it successfully on other path.
Go to Top of Page

kauts
Starting Member

India
2 Posts

Posted - 07/19/2010 :  03:50:18  Show Profile  Reply with Quote
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...
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000