Prev: SQL Server 2005: Management Studio missing after setup
Next: DBA Job Change
From: Daniel on 3 Mar 2010 08:27
On my SQL 2008 SP1 server it seems there is a loop of events for 3 of
the databases existing on this server.
On the Windows Application event log there are intermitently logged events

17137 Starting up database 'db'

and then

17573 CHECKDB for database 'db' finished without errors on yyyy-mm-dd
07:13:53.453 (local time). This is an informational message only; no
user action is required.

The date is from a previous maintenance plan. These avents are logged
every 20-30 minutes. Same events on SQL logs, too.
From: Andrew J. Kelly on 3 Mar 2010 09:44
Sounds like those databases may have Auto Close turned on. Each time a db is
brought online it will report the last known good DBCC CHECKDB for
reference. If auto close is not on then you might want to investigate why
these dbs are being brought off line so often.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Daniel" <dvasilciu(a)hotmail.com> wrote in message
news:uxEbTVtuKHA.6124(a)TK2MSFTNGP04.phx.gbl...
> On my SQL 2008 SP1 server it seems there is a loop of events for 3 of the
> databases existing on this server.
> On the Windows Application event log there are intermitently logged events
>
> 17137 Starting up database 'db'
>
> and then
>
> 17573 CHECKDB for database 'db' finished without errors on yyyy-mm-dd
> 07:13:53.453 (local time). This is an informational message only; no user
> action is required.
>
> The date is from a previous maintenance plan. These avents are logged
> every 20-30 minutes. Same events on SQL logs, too.

From: Daniel on 4 Mar 2010 00:28

You were right, Auto Close was the issue. Thanks a lot !

On 03.03.2010 16:44, Andrew J. Kelly wrote:
> Sounds like those databases may have Auto Close turned on. Each time a
> db is brought online it will report the last known good DBCC CHECKDB for
> reference. If auto close is not on then you might want to investigate
> why these dbs are being brought off line so often.
>

 | 
Pages: 1
Prev: SQL Server 2005: Management Studio missing after setup
Next: DBA Job Change