October 22, 2003 at 5:43 pm
Colleagues,
Can anyone tell me how to stop this analysis process from occurring ? This is the resulting message and I can't find how to disable this DB analysis feature ? Please share your thoughts on how I might be able to disable this.
Here's the message (bolded):
Event Type:Information
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:10/20/2003
Time:4:30:30 PM
User:N/A
Computer:ALBADE1
Description:
3455 :
Analysis of database 'ADE_Archive' (8) is 100% complete (approximately 0 more seconds)
I want to disable this Analysis process and message.
Thanks in advance.
October 24, 2003 at 1:26 pm
BCC,
This looks like the output from the startup of the SQL Server (you should see the last line in the SQL Server error log, as well -- one line for each DB on the server). AFAIK, you can't turn this off, nor would you want to.
If I understand correctly, this is SQL Server checking the transaction logs for DB Ade_Archive. If there were committed transactions that had not been written to disk prior to shutdown, they would be written at this point. Uncommitted transactions in the log would be rolled back. These are good things.
HTH,
Paul
October 24, 2003 at 1:39 pm
If you're seeing a lot of these messages, perhaps you've got one or more of the databases set to AUTO_CLOSE...
--Jonathan
--Jonathan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply