Help...Database openning and closing in log file

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Help...Database openning and closing in log file

Message

From

25/07/2000 16:16:30

Shawn Dorion
GeoSektor.com/Applications4u.com
Cardinal, Ontario, Canada

All

General information

Forum:

Microsoft SQL Server

Category:

Database management

Title:

Help...Database openning and closing in log file

Miscellaneous

Thread ID:

00396769

Message ID:

00396769

Views:

SQL7.0
Can any one help we were looking at out server logs and the database that we user is constantly opening and closing.
Example :
2000-02-08 10:34:55.34 spid8 Starting up database 'oslsk'.
2000-02-08 10:34:55.35 spid8 Opening file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:34:55.43 spid8 Opening file d:\mssql7\data\oslsk_Log.LDF.
2000-02-08 10:34:55.85 spid8 Closing file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:34:55.88 spid8 Closing file d:\mssql7\data\oslsk_Log.LDF.
2000-02-08 10:34:55.91 spid8 Starting up database 'osmkt'.
2000-02-08 10:34:55.91 spid8 Opening file g:\mssql7\data\osmkt.mdf.
2000-02-08 10:34:55.95 spid8 Opening file g:\mssql7\data\osmkt_log.ldf.
2000-02-08 10:34:56.45 spid8 Closing file g:\mssql7\data\osmkt.mdf.
2000-02-08 10:34:56.49 spid8 Closing file g:\mssql7\data\osmkt_log.ldf.
2000-02-08 10:34:56.52 spid8 Starting up database 'pubs'.
2000-02-08 10:34:56.52 spid8 Opening file d:\mssql7\DATA\pubs.mdf.
2000-02-08 10:34:56.56 spid8 Opening file d:\mssql7\DATA\pubs_log.ldf.
2000-02-08 10:34:58.71 spid8 Starting up database 'oslsk'.
2000-02-08 10:34:58.71 spid8 Opening file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:34:58.76 spid8 Opening file d:\mssql7\data\oslsk_Log.LDF.
2000-02-08 10:34:59.06 spid8 Closing file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:34:59.11 spid8 Closing file d:\mssql7\data\oslsk_Log.LDF.
2000-02-08 10:34:59.14 spid8 Starting up database 'oslsk'.
2000-02-08 10:34:59.14 spid8 Opening file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:34:59.18 spid8 Opening file d:\mssql7\data\oslsk_Log.LDF.
2000-02-08 10:34:59.59 spid8 Closing file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:34:59.64 spid8 Closing file d:\mssql7\data\oslsk_Log.LDF.
2000-02-08 10:34:59.66 spid8 Starting up database 'osmkt'.
2000-02-08 10:34:59.66 spid8 Opening file g:\mssql7\data\osmkt.mdf.
2000-02-08 10:34:59.70 spid8 Opening file g:\mssql7\data\osmkt_log.ldf.
2000-02-08 10:35:00.19 spid8 Closing file g:\mssql7\data\osmkt.mdf.
2000-02-08 10:35:00.22 spid8 Closing file g:\mssql7\data\osmkt_log.ldf.
2000-02-08 10:35:00.23 spid8 Starting up database 'osmkt'.
2000-02-08 10:35:00.23 spid8 Opening file g:\mssql7\data\osmkt.mdf.
2000-02-08 10:35:00.29 spid8 Opening file g:\mssql7\data\osmkt_log.ldf.
2000-02-08 10:35:00.80 spid8 Closing file g:\mssql7\data\osmkt.mdf.
2000-02-08 10:35:00.83 spid8 Closing file g:\mssql7\data\osmkt_log.ldf.
2000-02-08 10:35:08.80 spid8 Starting up database 'oslsk'.
2000-02-08 10:35:08.80 spid8 Opening file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:35:08.85 spid8 Opening file d:\mssql7\data\oslsk_Log.LDF.
2000-02-08 10:35:09.12 spid8 Closing file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:35:09.17 spid8 Closing file d:\mssql7\data\oslsk_Log.LDF.
2000-02-08 10:35:09.19 spid8 Starting up database 'oslsk'.
2000-02-08 10:35:09.19 spid8 Opening file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:35:09.24 spid8 Opening file d:\mssql7\data\oslsk_Log.LDF.
2000-02-08 10:35:09.74 spid8 Closing file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:35:09.79 spid8 Closing file d:\mssql7\data\oslsk_Log.LDF.
2000-02-08 10:35:09.81 spid8 Starting up database 'oslsk'.
2000-02-08 10:35:09.81 spid8 Opening file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:35:09.85 spid8 Opening file d:\mssql7\data\oslsk_Log.LDF.
2000-02-08 10:35:10.06 spid8 Starting up database 'osmkt'.
2000-02-08 10:35:10.06 spid8 Opening file g:\mssql7\data\osmkt.mdf.
2000-02-08 10:35:10.11 spid8 Opening file g:\mssql7\data\osmkt_log.ldf.
2000-02-08 10:35:10.60 spid8 Closing file g:\mssql7\data\osmkt.mdf.
2000-02-08 10:35:10.64 spid8 Closing file g:\mssql7\data\osmkt_log.ldf.
2000-02-08 10:35:10.73 spid8 Closing file d:\mssql7\data\oslsk_Data.MDF.
2000-02-08 10:35:10.79 spid8 Closing file d:\mssql7\data\oslsk_Log.LDF.

TIA
Shawn

Shawn Dorion
Geo Sektor Dot Com
Website: http://www.geosektor.com

Web Hosting Plans
Visit : http://WebHosting.Applications4u.com/

Map

View

Click here to load this message in the networking platform