Database Modification (Insert/Update/Delete) Event Notifications

Hello,

I am new to SQL Server and am building a C# application which will use a local SQL Server Express 2005installation. My application will be interacting with a DB Schema with approx 250 tables and the schema is already defined. My application is responsible for monitoring changes to the data in the DB. It must watch for all data changes in the database (Insert/Update/Delete). I am looking for a way to monitor changes to the DB data due to Insert/Update/Delete activity.

Is there a simple way in SQL Server for my application to receive events whenever the table content is modified. I have come up with a few ideas myself, for example adding trigger to each table to update an additional Event table that I could look at or even receive an Query Event on , but this swould mean creating and maitaining 750 triggers (250 tables x 3).

I can't help but feel there must be a simpler way, such as some type of SQL Audit or Monitoring feature that is already built in that could notifiy an application whenever there are DB data changes? Does such a feature exist? What would be the best way to accomplish this?

MarKGB

Trigger is invented mainly for this. If you have to audit every table, you could combine insert/update/delete event into 1 trigger. That will result in 250 triggers.|||

Hi,

if you are using SQL Server 2005 you can use the new query notification for getting the notification of changes to the database. In SQL Server 2000 I would suggest to go the way you already mentioned. Creating an event table and filling this via triggers based on the tables. Perhaps you can create a generic autiting trigger (Look in google for that there have been some samples arounf how to implement this.)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Great!, I didn't know you could combine the events to one trigger. That will certainly help reduce the amount of coding. Thanks!

Mark

|||

I did as you suggested and googled 'generic audit trigger' and got a lot of hits. In fact, I found a nice example that uses a generic CLR trigger and was able to get it working. The example can be found here:

http://sqljunkies.com/Article/4CD01686-5178-490C-A90A-5AEEF5E35915.scuk

I think using this in combination with a Query Event will give me what I am looking for.

Thanks for your help.

Mark

Database Maintenance plans log

I receive every 30 min 5 event into my event viewer application log telling
me something like this
18265 :
Log backed up: Database: UserDatabases, creation date(time):
2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
devices: 1, device information: (FILE=1, TYPE=DISK:
{'H:\SQLBackup\UserDatabases\UserDatabases_tlog_20 0505120800.TRN'}).
Is there a way to remove the log to event viewer from a maintenante plan?
First its not giving anything good and its hard to find error since my event
viewer is full of those information.
Hi
You might be logging it into an Event Viewer. Just try to update the same or
try to remove the logging
best Regards,
Chandra
http://chanduas.blogspot.com/
"fatp" wrote:

> I receive every 30 min 5 event into my event viewer application log telling
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> {'H:\SQLBackup\UserDatabases\UserDatabases_tlog_20 0505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my event
> viewer is full of those information.
>
|||Short answer: No. These entries are not written by Maint Plan nor by Agent. They are written by SQL
Server. Each time SQL Server does a backup, it will write that to the eventlog. For other error
messages, you can configure whether they should be written to the eventlog or not, but that
configuration (sp_altermessage) is ignored for backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"fatp" <fatp@.discussions.microsoft.com> wrote in message
news:AC8C5172-D6CA-4E33-8F36-D7D59B822692@.microsoft.com...
> I receive every 30 min 5 event into my event viewer application log telling
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> {'H:\SQLBackup\UserDatabases\UserDatabases_tlog_20 0505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my event
> viewer is full of those information.
>

Database Maintenance plans log

I receive every 30 min 5 event into my event viewer application log telling
me something like this
18265 :
Log backed up: Database: UserDatabases, creation date(time):
2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
devices: 1, device information: (FILE=1, TYPE=DISK:
{'H:\SQLBackup\UserDatabases\UserDatabases_tlog_200505120800.TRN'}).
Is there a way to remove the log to event viewer from a maintenante plan?
First its not giving anything good and its hard to find error since my event
viewer is full of those information.Hi
You might be logging it into an Event Viewer. Just try to update the same or
try to remove the logging
--
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"fatp" wrote:
> I receive every 30 min 5 event into my event viewer application log telling
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> {'H:\SQLBackup\UserDatabases\UserDatabases_tlog_200505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my event
> viewer is full of those information.
>|||Short answer: No. These entries are not written by Maint Plan nor by Agent. They are written by SQL
Server. Each time SQL Server does a backup, it will write that to the eventlog. For other error
messages, you can configure whether they should be written to the eventlog or not, but that
configuration (sp_altermessage) is ignored for backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"fatp" <fatp@.discussions.microsoft.com> wrote in message
news:AC8C5172-D6CA-4E33-8F36-D7D59B822692@.microsoft.com...
> I receive every 30 min 5 event into my event viewer application log telling
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> {'H:\SQLBackup\UserDatabases\UserDatabases_tlog_200505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my event
> viewer is full of those information.
>

Database Maintenance plans log

I receive every 30 min 5 event into my event viewer application log telling
me something like this
18265 :
Log backed up: Database: UserDatabases, creation date(time):
2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dum
p
devices: 1, device information: (FILE=1, TYPE=DISK:
& #123;'H:\SQLBackup\UserDatabases\UserDat
abases_tlog_200505120800.TRN'}).
Is there a way to remove the log to event viewer from a maintenante plan?
First its not giving anything good and its hard to find error since my event
viewer is full of those information.Hi
You might be logging it into an Event Viewer. Just try to update the same or
try to remove the logging
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"fatp" wrote:

> I receive every 30 min 5 event into my event viewer application log telli
ng
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of d
ump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> & #123;'H:\SQLBackup\UserDatabases\UserDat
abases_tlog_200505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my eve
nt
> viewer is full of those information.
>|||Short answer: No. These entries are not written by Maint Plan nor by Agent.
They are written by SQL
Server. Each time SQL Server does a backup, it will write that to the eventl
og. For other error
messages, you can configure whether they should be written to the eventlog o
r not, but that
configuration (sp_altermessage) is ignored for backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"fatp" <fatp@.discussions.microsoft.com> wrote in message
news:AC8C5172-D6CA-4E33-8F36-D7D59B822692@.microsoft.com...
> I receive every 30 min 5 event into my event viewer application log tellin
g
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of d
ump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> & #123;'H:\SQLBackup\UserDatabases\UserDat
abases_tlog_200505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my eve
nt
> viewer is full of those information.
>

Database Maintenance Plan

A previous employee created the plan t0 back up TRN and BAK files.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?
I don't think you can change the plan owner, but you can try changing the owner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up your plan...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegr oups.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>
|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.

Database Maintenance Plan

A previous employee created the plan t0 back up TRN and BAK files.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?I don't think you can change the plan owner, but you can try changing the owner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up your plan...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegroups.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.

Database Maintenance Plan

A previous employee created the plan t0 back up TRN and BAK files.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?I don't think you can change the plan owner, but you can try changing the ow
ner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up
your plan...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegroups
.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.

Database Logs are being truncated

Hi,
Can someone help me with a SQL error that I'm getting in my event log. The
error is listed below.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 12/15/2003
Time: 12:03:47 AM
User: N/A
Computer: SQL-SERVER
Description:
18278 :
Database log truncated: Database: model.
Data:
0000: 66 47 00 00 10 00 00 00 fG.....
0008: 0b 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 2d 00 53 00 45 00 L.-.S.E.
0018: 52 00 56 00 45 00 52 00 R.V.E.R.
0020: 00 00 06 00 00 00 6d 00 .....m.
0028: 6f 00 64 00 65 00 6c 00 o.d.e.l.
0030: 00 00 ..
This is happening on 4 of my databases. 2 created by me, Crystal Reports
database (CE8), and the model database.
I'm backing up all db's and the logs for the 4 db's mentioned above full
every day. This problem has been happening long before I decided to backup
the logs though. I thought backing up the logs would fix this problem. The
4 db's above all have Recovery set to "Full", because log backups were
failing when Recovery was set to "Simple" and the error suggested that
recovery be set to something other than "Simple".
I increased the size of the db's and logs to 100 meg, but that didn't help.
Also the size kept going back to a small number. Now I set the databases to
grow automatically, but I set the maximum size allowed to grow to 100 meg
for both db's and logs. The db's are between 2 to 5 megs though.
We write about 100 - 200 lines of data to the server every day. We don't
use Crystal Reports anymore and I'm not sure what the model db is for. The
db grows very slowly.
Thanks!!!
DaveRegarding the error you see, check this article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;818202&Product=sql2k
replies in line.
Steve
"Dave" <none@.none.com> wrote in message
news:O06b7MMxDHA.1596@.TK2MSFTNGP10.phx.gbl...
> Can someone help me with a SQL error that I'm getting in my event log.
The
> error is listed below.
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (6)
> Event ID: 17055
> Date: 12/15/2003
> Time: 12:03:47 AM
> User: N/A
> Computer: SQL-SERVER
> Description:
> 18278 :
> Database log truncated: Database: model.
> Data:
> 0000: 66 47 00 00 10 00 00 00 fG.....
> 0008: 0b 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 2d 00 53 00 45 00 L.-.S.E.
> 0018: 52 00 56 00 45 00 52 00 R.V.E.R.
> 0020: 00 00 06 00 00 00 6d 00 .....m.
> 0028: 6f 00 64 00 65 00 6c 00 o.d.e.l.
> 0030: 00 00 ..
> This is happening on 4 of my databases. 2 created by me, Crystal Reports
> database (CE8), and the model database.
> I'm backing up all db's and the logs for the 4 db's mentioned above full
> every day. This problem has been happening long before I decided to
backup
> the logs though. I thought backing up the logs would fix this problem.
The
> 4 db's above all have Recovery set to "Full", because log backups were
> failing when Recovery was set to "Simple" and the error suggested that
> recovery be set to something other than "Simple".
> I increased the size of the db's and logs to 100 meg, but that didn't
help.
> Also the size kept going back to a small number. Now I set the databases
to
> grow automatically, but I set the maximum size allowed to grow to 100 meg
> for both db's and logs. The db's are between 2 to 5 megs though.
> We write about 100 - 200 lines of data to the server every day. We don't
> use Crystal Reports anymore and I'm not sure what the model db is for. Th
e
> db grows very slowly.
There is no reason to set the recovery mode on model to full, simple would
be fine. Model is used as a template when you create new databases.
Steve|||Hi Steve,
Thanks for article. Here's the code for the log backups. It looks like
that I don't have the NO_LOG or the TRUNCATE_ONLY options set. I changed
the recover mode of the databases to bulk logged. I'll see if that helps.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
E79DF926-E729-4FA2-8769-62EE4F86120E -Rpt "C:\Program Files\Microsoft SQL
Server\MSSQL\LOG\DB Maintenance Plan - Log Backups6.txt" -DelTxtRpt
2WEEKS -WriteHistory -VrfyBackup -BkUpMedia
ISK -BkUpLog -UseDefDir -DelBkUps 2WEEKS -CrBkSubDir -BkExt "TRN"'
Thanks!!!|||Hi Dave,
Let us know if that helps... if it doesn't we can give you some alternatives
to maintenance plans.
Steve
"Dave" <none@.none.com> wrote in message
news:#$gd3DNxDHA.2156@.TK2MSFTNGP09.phx.gbl...
> Hi Steve,
> Thanks for article. Here's the code for the log backups. It looks like
> that I don't have the NO_LOG or the TRUNCATE_ONLY options set. I changed
> the recover mode of the databases to bulk logged. I'll see if that helps.
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> E79DF926-E729-4FA2-8769-62EE4F86120E -Rpt "C:\Program Files\Microsoft SQL
> Server\MSSQL\LOG\DB Maintenance Plan - Log Backups6.txt" -DelTxtRpt
> 2WEEKS -WriteHistory -VrfyBackup -BkUpMedia
> ISK -BkUpLog -UseDefDir -DelBkUps 2WEEKS -CrBkSubDir -BkExt "TRN"'
> Thanks!!!
>|||Still getting the error after I set the recovery mode to bulk logged.
Is it possible that my space allocation for the logs isn't working right?
Here's what my setup looks like for one of my db's that's generating the
error.
&Transaction Log Files
Space Allocated = 3Mb
File Properties
Automatically Grow File = Checked
In Megabytes = 3
Restrict File Growth (MB) = 100
What else can I look at?
Thanks!
Dave|||Sometimes autogrow doesn't seem to "catch up". I suggest that you pre-allocate storage.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Dave" <none@.none.com> wrote in message news:OudZx1YxDHA.2328@.TK2MSFTNGP10.phx.gbl...
> Still getting the error after I set the recovery mode to bulk logged.
> Is it possible that my space allocation for the logs isn't working right?
> Here's what my setup looks like for one of my db's that's generating the
> error.
> &Transaction Log Files
> Space Allocated = 3Mb
> File Properties
> Automatically Grow File = Checked
> In Megabytes = 3
> Restrict File Growth (MB) = 100
> What else can I look at?
> Thanks!
> Dave
>|||I agree with Tibor -- pre-allocate the database and transaction log size to
the estimated total size needed. Also, consider setting the recovery mode to
'simple' for the system databases; master, msdb, model & tempdb. Do place
the first three on a full backup cycle though...
Steve
"Dave" <none@.none.com> wrote in message
news:OudZx1YxDHA.2328@.TK2MSFTNGP10.phx.gbl...
> Still getting the error after I set the recovery mode to bulk logged.
> Is it possible that my space allocation for the logs isn't working right?
> Here's what my setup looks like for one of my db's that's generating the
> error.
> &Transaction Log Files
> Space Allocated = 3Mb
> File Properties
> Automatically Grow File = Checked
> In Megabytes = 3
> Restrict File Growth (MB) = 100
> What else can I look at?
> Thanks!
> Dave
>|||I have tried the following in the past and have not had success.
Under database properties->Transaction Log->&Transaction Log Files I
increased the Space Allocated (MB) field to 100 MB. It seemed to work, but
when I checked this again the next day, the space allocated value was down
to a small number (3 MB). Am I doing this right?
Thanks!!!
Dave|||Hi Steve,
I set model back to Simple recovery mode so I have all databases on Simple
recovery mode except for the 2 that we created and the Crystal Reports db.
I noticed something strange in the event log that I hadn't noticed before.
My backup schedule for the databases(not the logs) was at 5am, but the event
log says they're being backed up at around 12 am and this is when the errors
are occuring. The backups excecute again again at 5am successfully with no
event log errors. The logs get backed up successfully on schedule at 6:00
am. I'm guessing that the 12 o'clock backups are caused by our tape backup
software(Tapeware) which has a sql server connector option that we bought.
The Tapeware backups are scheduled at 12:01am every day. This is the only
thing I can think of that would cause the backups at around 12am.
Anyway, I'm going to disable the sql backups on Tapeware for a day and see
if I still get errors.
Should I not back up the logs for model? Simple recovery models cause log
backup errors.
Thanks!!!
Dave|||> Should I not back up the logs for model?
I'd say its overkill.
> Simple recovery models cause log
> backup errors.
IF you set model to simple, then don't do log backups for model, quite
simply.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Dave" <none@.none.com> wrote in message
news:u8j09FlxDHA.2568@.TK2MSFTNGP09.phx.gbl...
> Hi Steve,
> I set model back to Simple recovery mode so I have all databases on Simple
> recovery mode except for the 2 that we created and the Crystal Reports db.
> I noticed something strange in the event log that I hadn't noticed before.
> My backup schedule for the databases(not the logs) was at 5am, but the
event
> log says they're being backed up at around 12 am and this is when the
errors
> are occuring. The backups excecute again again at 5am successfully with
no
> event log errors. The logs get backed up successfully on schedule at 6:00
> am. I'm guessing that the 12 o'clock backups are caused by our tape
backup
> software(Tapeware) which has a sql server connector option that we bought.
> The Tapeware backups are scheduled at 12:01am every day. This is the only
> thing I can think of that would cause the backups at around 12am.
> Anyway, I'm going to disable the sql backups on Tapeware for a day and see
> if I still get errors.
> Should I not back up the logs for model? Simple recovery models cause log
> backup errors.
> Thanks!!!
> Dave
>
>|||Thanks Tibor,
I disabled our tape backup software sql server backup function and the
errors went away.
My maintenance plan backups are working without any errors.
I'm going to assume that the sql server is working fine even though I'm
getting the log truncated errors. I don't think I can do anything to fix
that. Is this a good assumtion?
Thanks!!!

Database log truncated: Database: MyDatabase.

Hi,

My Database recovery model is set to Bulk Logged. I recently got this error in the Application Event Log.

EVENT LOG Application
EVENT TYPE Error
SOURCE MSSQLSERVER
CATEGORY Backup
EVENT ID 17055
MESSAGE 18278 :
Database log truncated: Database: MyDatabase.

I've checked the MS Knowledgebase, however article 818202 relates to Full Recovery model not Bulk Logged. I would like to know why this error has occurred and what it really means.

Cheers

DamianThis is not an error, it's just information only message. It's no different than when you issue a Truncate_only log backup.

Database log truncated: Database: MyDatabase.

Hi,
My Database recovery model is set to Bulk Logged. I
recently got this error in the Application Event Log.
EVENT LOG Application
EVENT TYPE Error
SOURCE MSSQLSERVER
CATEGORY Backup
EVENT ID 17055
MESSAGE 18278 :
Database log truncated: Database: MyDatabase.
I've checked the MS Knowledgebase, however article 818202
relates to Full Recovery model not Bulk Logged. I would
like to know why this error has occurred and what it really
means.
Cheers
DamianIt means you (or someone) did a BACKUP LOG WITH TRUNCATE_ONLY or =similar statement. And the log files can not be used for recovery until =the next full db backup is taken.
Mike John
"Damian Jolly" <damian.jolly@.sageautomation.com> wrote in message =news:38fe01c3c8dc$ba792e10$7d02280a@.phx.gbl...
> Hi,
> > My Database recovery model is set to Bulk Logged. I
> recently got this error in the Application Event Log.
> > EVENT LOG Application > EVENT TYPE Error > SOURCE MSSQLSERVER > CATEGORY Backup > EVENT ID 17055 > MESSAGE 18278 :
> Database log truncated: Database: MyDatabase.
> > I've checked the MS Knowledgebase, however article 818202
> relates to Full Recovery model not Bulk Logged. I would
> like to know why this error has occurred and what it really
> means.
> > Cheers
> > Damian|||To add to Mike's response, I ran the repro script in the MSKB article but
with the recovery model set to BULK_LOGGED. The error also appeared in the
log with BULK_LOGGED recovery.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Damian Jolly" <damian.jolly@.sageautomation.com> wrote in message
news:38fe01c3c8dc$ba792e10$7d02280a@.phx.gbl...
> Hi,
> My Database recovery model is set to Bulk Logged. I
> recently got this error in the Application Event Log.
> EVENT LOG Application
> EVENT TYPE Error
> SOURCE MSSQLSERVER
> CATEGORY Backup
> EVENT ID 17055
> MESSAGE 18278 :
> Database log truncated: Database: MyDatabase.
> I've checked the MS Knowledgebase, however article 818202
> relates to Full Recovery model not Bulk Logged. I would
> like to know why this error has occurred and what it really
> means.
> Cheers
> Damian