SQL Server Log: Starting up database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rubens - 03 Mar 2008 13:43 GMT

My SQL Server Log shows a ton of records starting up two different
databases. One of them was an old test database of mine, so I deleted it.
However, the other is a production database, recovery mode set to simple.

Can someone tell me why these particular databases were / are showing up as
starting constantly? To the best of my knowledge, this should only happen
when SQL is restarted, correct?

This is on a SQL 2000 SP4 server.

Thank-you,
Rubens

Reply to this Message

Russell Fields - 03 Mar 2008 14:34 GMT

Rubens,

It sounds like the database is set to AUTO CLOSE. You want to turn that
off.

ALTER DATABASE YourDB SET AUTO_CLOSE OFF

RLF

> My SQL Server Log shows a ton of records starting up two different
> databases. One of them was an old test database of mine, so I deleted it.
[quoted text clipped - 9 lines]
> Thank-you,
> Rubens

Reply to this Message

Rubens - 03 Mar 2008 15:09 GMT

Thank-you Russell, that's exactly what it was. I looked this up in BOL to
see what that option does and this database should definitely not be set to
auto close.

Thanks,
Rubens

> Rubens,
>
[quoted text clipped - 20 lines]
>> Thank-you,
>> Rubens

Reply to this Message

Greg D. Moore (Strider) - 03 Mar 2008 23:58 GMT

Most should not be. ;-)

Was this perhaps upgraded from something like SQL Server Express

Signature

Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

> Thank-you Russell, that's exactly what it was. I looked this up in BOL to
> see what that option does and this database should definitely not be set
[quoted text clipped - 28 lines]
>>> Thank-you,
>>> Rubens

Reply to this Message

Rubens - 04 Mar 2008 00:07 GMT

SQL Server Express? Don't you mean MSDE for us guys who haven't even
upgraded our prod servers from SQL 2000 yet? Sigh!

I'm really not sure why this option was turned on, nor who would have done
it. I am almost wondering if this was created in Dev that way and then at
some point scripted or restored to production when we first went live with
it. Either way, I'm glad I know what that option is for and I can make sure
it will never be enabled again unless it is the right choice for that
particular database.

Thanks Greg!

Rubens

> Most should not be. ;-)
>
[quoted text clipped - 32 lines]
>>>> Thank-you,
>>>> Rubens

Reply to this Message

Greg D. Moore (Strider) - 04 Mar 2008 02:46 GMT

> SQL Server Express? Don't you mean MSDE for us guys who haven't even
> upgraded our prod servers from SQL 2000 yet? Sigh!

Hence the "like" :-)

> I'm really not sure why this option was turned on, nor who would have done
> it. I am almost wondering if this was created in Dev that way and then at
> some point scripted or restored to production when we first went live with
> it. Either way, I'm glad I know what that option is for and I can make
> sure it will never be enabled again unless it is the right choice for that
> particular database.

I believe by default it's turned on in MSDE.

> Thanks Greg!
>
[quoted text clipped - 36 lines]
>>>>> Thank-you,
>>>>> Rubens

Signature

Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Reply to this Message

Rubens - 04 Mar 2008 02:56 GMT

Haha... I missed that originally!

:-)

>> SQL Server Express? Don't you mean MSDE for us guys who haven't even
>> upgraded our prod servers from SQL 2000 yet? Sigh!
[quoted text clipped - 50 lines]
>>>>>> Thank-you,
>>>>>> Rubens

Reply to this Message