If you review the install log does it show any errors while trying to install SSMS or any portion of the desktop tools while it was upgrading them?

What OS is this installed on?

Just shoot'n from the keyboard here....Could you enable "Successful Logons" for that instance and then correlate the timestamp of the backup with the logon time to see what client/IP it...

The application is it working with could be firing the backups.

If you query the msdb.dbo.backupset table it should give you the username issuing the backup command.

I attached a script I...

Well from my reading:-D, workspace memory (or query memory) is used by SQL when doing hash/sort operations. This memory is also pulled out of the buffer pool. So I...

Did this job work prior? Are you aware of anything that changed if it did previously work (SP, CU installs)? Missed you stated you created it:-P

Is this server a...

If you have the job set to output to a log does that give you any information?

Here's one I've used, similar to homebrew01's just pull from few more tables:SELECT distinct t1.name AS 'DatabaseName'

,(datediff( ss, t3.backup_start_date, t3.backup_finish_date)) AS 'DurationInSeconds'

,t3.user_name AS 'UserResponsible'

,t3.name AS backup_name

,t3.description

,t3.backup_start_date

,t3.backup_finish_date

,CASE

WHEN t3.type = 'D'...

That's funny :w00t:

Anyway...

I was in the same boat 2 companies back. I worked more than the 8 hours in a...

The SQL ERRORLOG should give you a message with the estimated time remaining, not sure if it gives an updated message or not.

Ah HIPAA is such a great tool for job security:-D

I know the previous employer I was at we looked at a few applicances for central logging, but don't recall the...

If you go and check Windows Features do you see the box checked (or colored blue) for the .NET framework 3.5. I'm not at my Windows 7 box, but I...

I remember where I've seen mention of nHibernate now...Grant Fritchey (aka ScaryDBA) talks about it on his blog:

http://scarydba.wordpress.com/2010/04/05/nhibernate-first-look-at-tsql/%5B/url%5D

Which I believe his post is exactly what you maybe seeing.

SCC has numerous post on database states that you might want to browse.

Are you saying the delete statement took 2 days then the database server was rebooted? Or the database...

lorisj33 (6/7/2010)

---

How do you feel about monitoring database activity from the network level for compliance? Do you currently do this via an appliance, and how is it working out...