Microsoft SQL Server Administration

Is it possible to find out when a database was last modified, or logged into? Will looking at the data and log file to see when they where last modified at OS level do this? Thanks Adam ...

I installed SQLH2 - followed directions closely :). All seem to work as described, except for the performance data. I am consistently receiving. 1/31/2007 10:32:55 AM     INFO:     C:\SQLH2\PerfCollector\Data\pfc013107072759.txt: fid = 16, state = 0, retry ...

We are experiencing error in login connections during an automatic failover in a database mirroring session. Anyone who has had similar problem that can send suggestions/ideas greatly appretiated! Thank you ...

I'm currently doing differential backups via the following scheduled job command: BACKUP DATABASE [DATABASE] TO  DISK = N'c:\backup\DATABASE- Differential' WITH  INIT ,  NOUNLOAD ,  NAME = N'DATABASE differential backup',  NOSKIP , DIFFERENTIAL, STATS = 10,  NOFORMAT ...