Groups | Blog | Home
all groups > sql server notification services > september 2004 >

sql server notification services : Notifications log file


Tamim
9/14/2004 5:11:03 AM
Hi all,
I need to keep notifications log history for each subscriber to be viewed
later, problem is NS periodically deletes the events to improve speed, isn't
there any event i can use to backup data to another table before vacuumer
deletes it? I hope there might be a simple way, instead of triggers or
Colin Meek [MSFT]
9/14/2004 7:53:14 AM
By setting the <RetentionAge> in the application definition file
(ApplicationExecutionSettings/Vacuum), you can control how long records are
retained, including the distribution log.

- Colin Meek [MSFT]

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.
--

[quoted text, click to view]

AddThis Social Bookmark Button