Date the DB was brought online

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ba_wvu - 30 Apr 2008 16:45 GMT

Is there any way to tell the date and time a database was brought
online. I'm using Performance Dashboard and trying to determine IOPS
without restarting the server, so I'm looking to calculate IOPS using
the database's time currently online.

Reply to this Message

Tibor Karaszi - 30 Apr 2008 17:17 GMT

Can you explain exactly what you mean by "brought online". Created? SQL Server started? Something
else?

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Is there any way to tell the date and time a database was brought
> online. I'm using Performance Dashboard and trying to determine IOPS
> without restarting the server, so I'm looking to calculate IOPS using
> the database's time currently online.

Reply to this Message

ba_wvu - 30 Apr 2008 17:49 GMT

I'm looking for the date the db was last brought online.

Reply to this Message

Roy Harvey (SQL Server MVP) - 30 Apr 2008 18:45 GMT

>I'm looking for the date the db was last brought online.

Look at the SQL Server Log. When SQL Server starts there is a message
for each database "Starting up database <name>." I assume a similar
message would appear if the database were taken off-line, or brought
back on-line, regardless of what you actually mean by that.

Roy Harvey
Beacon Falls, CT

Reply to this Message