Turn Off AUTO_CLOSE

Rating:

(0)

Brian Moran

SQL Server Magazine

InstantDoc ID #42589

My SQL Server logs contain messages such as "2003-12-01 21:34:56 50 spid51 Starting Up Database 'IhateSpam'." Is it typical for SQL Server to constantly restart all my databases?

The AUTO_CLOSE option is probably enabled for the databases that SQL Server is regularly restarting. AUTO_CLOSE closes the database when the last user closes his or her connection and all processes in the database have completed. When a user then tries to connect to the database, SQL Server reopens the database, generating the message you describe.

By ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

There are no comments to display. Be the first one!

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

The Essential Guide to Mission-Critical Microsoft SQL Server
A Essential Guides by EMC

Tuna Helper - Tuning SQL Statements: A Proven Process for SQL Server Environments
A White Papers by Confio

A Business Case for Lowering Enterprise Total Cost of Ownership - Microsoft SQL Server for SAP on HP Integrity Servers
A White Papers by Hewlett-Packard

SSIS Performance Tuning, Connecting to Heterogeneous Sources, and Complex Transformations
A White Papers by expressor software

Paid Case Study of Sr. IT Professionals in $1B+ companies who migrated from Sybase/ Oracle to SQL Server 2008

Pique Solutions (www.piquesolutions.com), a premier consulting firm working with Fortune 500 technology vendors, is developing a video Case Study on b...