I have a SQL 2005 instance with a lot of activity on it. I would like to see some kind of loading usage information for the last couple of weeks, something that would tell me what time of the day it has the most users, and other relevant stats. Ideally I would like to see a graph with this information. Is there something already in SQL I could use for this?
I think what you are looking for is SQL Monitor 3 at: http://www.red-gate.com/
This is a product review to have a look at also: https://www.simple-talk.com/sql/sql-tools/top-six-sql-monitor-metrics-for-analysis/
Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed